Member-only story
3 Ways to Replace Multiple Column Values in Power BI 📈
Let’s understand by using Power Query transformation effectively
🎖️ Article was awarded as Must-Read by Power BI Masterclass community.
When discussing solutions in Power BI, people often solve issues either through SQL at the source or using DAX in Power BI Desktop.
However, not everything should be done that way. Developers often overlook Power Query or M Language transformations, which are integral parts of Power BI.
Certain transformations can be done in the Power Query Editor window of Power BI and we will discuss one such transformation here.
When we load raw data into Power BI, we often observe anomalies that require transformations before the data is ready for reporting. One such transformation is replacing unwanted values/characters in a column with new ones.
Let me tell you, this transformation can be done in different ways, and here we will discuss three of them, from the least to the most optimized way. But first, let’s understand the problem statement.
Problem Statement
You have a Sales table in your model, and the “Item Type” column has some old values that you want to replace with new ones. It is also observed that some values with more than one…
