topic Re: Help with writing AND DAX command in DAX Commands and Tips

Help with writing AND DAX command

Anonymous — Sun, 30 Apr 2023 12:41:33 GMT

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 — Sun, 30 Apr 2023 14:30:13 GMT

hi Anonymous

you can use switch in your dax query

I think this title will be helpful for you:

FreemanZ — Mon, 01 May 2023 00:04:59 GMT

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"

)