Forum Discussion

LTi's avatar
LTi
Frequent Visitor
3 years ago

struggling with else if function in power query

Good evening, I've tried to create a test logic using an if then function. It is about the evaluation of the Value column. If this column contains the percentage value less than 50%, then "critical"...
Need Help
ppm1's avatar
ppm1
Solution Sage
3 years ago

Please try this instead.

 

= if[#"value %"] <= 0,50 then "critical" else
if [#"value %"] > 0,50 and [#"value %"] <= 0,75 then "slightly critical" else "OK"

 

Pat

LTi's avatar
LTi
Frequent Visitor
3 years ago

Hi Pat, thank you for your assistance but it still doesn't work.

Error: expected token: 'then'