Skip to main content

Power BI

Needs Votes

Conditional Columns with Multiple Criteria in Power Query

Vote (4) Share
Greg's profile image

Greg on 30 Oct 2017 22:53:00

The Conditional Column button is very handy however often it is necessary to qualify a condition using two different criteria (ex. if [Fruit Type] = "Apples" and [Amt Sold] > 5 then "Top Seller"), it would be very handy to have this as an added feature.

Going one step further, often there are multiple sets of conditions that define a value. Ex. if ([Fruit Type] = "Apples" and [Amt Sold] > 5) or ([Fruit Type] = "Banana" and [Amt Sold] > 10) then "Top Seller". Right now this can be done by just using the exact spelling of "Top Seller" on a second conditional line, however that produces longer/unneeded code.