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" should be output, if this value is greater than 50% but less than or equal to 70%, then "slightly critical" should be output otherwise OK. Unfortunately, the formula below does not work. Who can take a look at this and have a solution suggestion for me? Thanks in advance.

 

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

Need Help

3 Replies

  • 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'

  • 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