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
hashtag_pete's avatar
hashtag_pete
Helper V
3 years ago

Hi LTi, 
you can paste this formular

= Table.AddColumn(#"ChangeTo PreviousStep", "Custom", each if [#"value %"] <= 0.5 then "critical" else if [#"value %"] <= 0.7 then "slightly critical" else "OK")

 

Best

hashtag_pete

 

PS: if successfull, please give kudos and mark as solution