Forum Discussion
SWITCH formula
Hi, I have a problem with the switch formula. I would like to list different margin groups. I have included a separate table in the query, namely: I have the following switch formula: ...
Hi rubayatyasmin,
Thank you for your reply.
I am quite new to Power BI and still have a lot to learn.
How do I check conditions from highest to lowest?
I do see that something goes wrong when I put it in an matrix. It looks like this:
How can I fix this?
Thanks in advance!
By try checking highest to lowest I meant to reverse your switch statements condition. Like write >15% first then <=10-15% then <= 8-10% and so on.