If we asked you if your data was clean and organized, you would probably say yes. However, data usually always has issues. For example, in a field for State, some users could enter NY
and some could enter New York
, along with a lot of other variations that include N.Y.
, N. York
, and more. If the state of New York is spelled out in just these four ways, that is four separate entities as far as your computer is concerned. Your machine does not have the capacity to interpret the meaning, only exactly what is entered, even though you may occasionally think the computer hates you.
One of the tools that Power BI Query Editor has that helps with this kind of situation is the Replace Values feature. This feature is similar to Find and Replace in Excel. Let's see how this works now:
In Query Editor, select the
Vendors
query in the Queries pane.Highlight the 1099 Type column.
On the ribbon, select Replace Values in the Any Column section of the Transform menu:
In the Replace Values...