Forum Discussion
IF AND
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
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!
3 Replies
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!
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
