Forum Discussion

Saffira's avatar
Saffira
New Member
3 years ago

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:

 

The problem is that the categories are not caught properly. For example, in a table I see someone with a 10% margin still listed with the from 15% and above.
How can I solve this? Thanks in advance!

3 Replies

  • Saffira's avatar
    Saffira
    New Member
    3 years ago

    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!

     

    • rubayatyasmin's avatar
      rubayatyasmin
      Community Champion
      3 years ago

      Saffira 

       

      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.