Forum Discussion
How to Create Measure for Multiple Criteria in Power Query
Hello, I need help creating the following measures in Power Query and Power BI separately: Measure If the “Cost variance” is less than or equal to -$10,000 and is -10% or Greater, retur...
Thanks for the quick response. I just want to make sure am doing this correctly because it's showing an error message
The above was DAX
In the Query Editor the formula would be...
= if [Cost Variance] <= -10000 and [#"% Change"] <= -.1 then "Under Budget"
else if [Cost Variance] >= 10001 and [#"% Change"] >= .1 then "Over Budget"
else if [Cost Variance] >= 9999 and [Cost Variance] <= 10000 then "On Target"
else null
