IF AND

[Anonymous]

Hi,

Where in Excel you can have 3 parameters passed to the IF AND function, what would you recommend to use in DAX as it only allows 2?

Would it be Switch, or something else?

Thanks

Liam

[Pragati11]

Hi @Anonymous ,

You can use nested IF-ELSE statement in DAX or SWITCH function.

IF-ELSE: https://docs.microsoft.com/en-us/dax/if-function-dax

SWITCH: https://radacad.com/write-conditional-statement-using-switch-in-dax-and-power-bi

Thanks,

Pragati

[harshnathani · Accepted solution]

Hi @Anonymous ,

Try using SWITCH () function

SWITCH(
TRUE(),

Table[Column1]  = "A", "Returns A",

Table[Column1]  = "B", "Returns B",

Table[Column1]  = "C", "Returns C",

"others"

)

You can have a look at the videos.

https://www.youtube.com/watch?v=-ykkaAtlCMc&vl=en

https://www.youtube.com/watch?v=UsAJPIANAb8

For Nested IFs

https://www.youtube.com/watch?v=rXDomxfoY1o

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

thankyou @harshnathani