Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

Multiple IF statements under Return

I am sharing my Pbix file here.   I am trying to have multiple IF statements under Retrurn statement. I was able to possibly have up to 2 options, when I got to 3 options, I am not sure I am doing...
Help with DAX
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi JustinDoh1 ,

 

We are putting OR and AND statements instead of them.

 

Also, put this statements in your Return part of your existing measure.

 

 

Thanks

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

Tanushree_Kapse Thanks for quick reply. While I am still trying to put your code so that there is no error message, I have a quick question. So, in DAX we do not use && or || ? I am looking at other part of code where I used && and ||. 

BTW, I am trying to apply your code here, but I am not sure I am doing it right.