cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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"

3 REPLIES 3
Helper V

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

Solution Sage

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

Pat

Microsoft Employee
Frequent Visitor

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

Error: expected token: 'then'

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.