Let’s say you need to add a new column to a large Power BI table depending on certain criteria. In this case, the conditional column option in Power BI is really helpful as it significantly simplifies the work.
In this Power BI tutorial, I will explain how to add Conditional column in Power BI and the Conditional Column in Power Query. Also, we will discuss the topics below:
- Power BI conditional column between values
- Power BI conditional column multiple conditions
- Power BI DAX conditional column
- Power BI conditional column based on two columns
- Power query conditional column if blank
- Power BI conditional column null
Conditional Column in Power BI
The Power BI Conditional column allows you to create a new column in your dataset based on specific conditions. In Power BI, we can create a conditional column using Power Query Editor.
For example, you could tell Power BI, “If this condition is met, put this value in the new column; if not, put a different value.
How to Add Conditional Column in Power Query
Let’s say you have a dataset containing information about products, their prices, and the quantity sold.
Now follow the below steps on how to add a conditional column in Power BI:
1. Open Power BI Desktop and load the data set. Then, in the Data pane, you can see your data set.
2. Then, under the Home tab, click Transform data.
3. In the Power Query Editor, click Conditional Column under the Add Column tab.
4. Provide the new column name as “Conditional Column.” Next, select the column name as “Total Sales,” choose the operator “is greater than,” set the value as “5000,” and the output as “High.”
Then, click on “Add clause.” For the ElseIf part, select the column name as “Total Sales,” the operator as “is less than,” set the value as “3000,” and the output as “Low.”
Finally, in the Else part, enter “Medium.” Click on “OK” to apply the changes.
5. Then, you can see a new column added in the Power Query editor.
This way, you can add a conditional column in Power BI.
Power BI Conditional Column Between Values
Let’s see how to create a conditional column between values in Power BI.
For this example, we will create a conditional column that checks the Aging column. If the aging value is less than 3, it’ll be labeled as ‘Fast delivery.’ If