Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
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
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
Hi Pat, thank you for your assistance but it still doesn't work.
Error: expected token: 'then'