5 then "Top Seller"), ..."> 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." />
web
You’re offline. This is a read only version of the page.
close
Skip to main content

    Power BI

    New

    Conditional Columns with Multiple Criteria in Power Query

    Vote (3) 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.