Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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!
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
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!
User | Count |
---|---|
84 | |
77 | |
64 | |
51 | |
46 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |