Help with writing AND DAX command

[Anonymous]

this is the original excel command : 

=IF(Y2>=60%,"Fresh",IF(AND(Y2<60%,Y2>=30%),"NE",IF(AND(Y2<30%,Y2>=5%),"VNE","Expired")))

, i want to write it in power bi with a column named [custom].

I'd appreciate some help.

Thank you

[ShirinArshadnia · Accepted solution]

hi @Anonymous 

you can use switch in your dax query 

I think this title will be helpful for you:

https://blog.enterprisedna.co/using-advanced-dax-for-multiple-if-statement-in-power-bi/

[FreemanZ · Accepted solution]

hi @Anonymous 

try to create a calculated column like:

Column =

SWITCH(

    TRUE(),

    [custom]>=0.6, "Fresh",

    [custom]>=0.3, "NE",

    [custom]>=0.05, "VNE",

    "Expired"

)

[ShirinArshadnia · Accepted solution]

hi @Anonymous 

you can use switch in your dax query 

I think this title will be helpful for you:

https://blog.enterprisedna.co/using-advanced-dax-for-multiple-if-statement-in-power-bi/