Forum Discussion
Help with writing AND DAX command
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
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/
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")
2 Replies
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/
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")