Forum Discussion
IF with multiple conditions
- Anonymous6 years ago
Hey Anonymous
You can use the AND and OR functions or even embed IF statements in Power BI just like you can in excel if you have an if function with multiple criteria.
AND: https://docs.microsoft.com/en-us/dax/and-function-dax
OR: https://docs.microsoft.com/en-us/dax/or-function-dax
Depending on your situation you may also want to consider the SWITCH function: https://docs.microsoft.com/en-us/dax/switch-function-dax
Examples: https://community.powerbi.com/t5/Desktop/DAX-Measure-with-Nested-IF-Statements/td-p/113358
https://stackoverflow.com/questions/40254578/multiple-if-statements-in-dax
If this helps please kudo.
If this solves your problem please accept it as a solution.
Hey Anonymous
You can use the AND and OR functions or even embed IF statements in Power BI just like you can in excel if you have an if function with multiple criteria.
AND: https://docs.microsoft.com/en-us/dax/and-function-dax
OR: https://docs.microsoft.com/en-us/dax/or-function-dax
Depending on your situation you may also want to consider the SWITCH function: https://docs.microsoft.com/en-us/dax/switch-function-dax
Examples: https://community.powerbi.com/t5/Desktop/DAX-Measure-with-Nested-IF-Statements/td-p/113358
https://stackoverflow.com/questions/40254578/multiple-if-statements-in-dax
If this helps please kudo.
If this solves your problem please accept it as a solution.
- Anonymous6 years agoNot applicable
Thanks! with SWITCH function is working, I just validate it.
🙂