Forum Discussion

Pandadev's avatar
Pandadev
Post Prodigy
5 years ago
Solved

Replicate Dax SWITCH code in Query editor

Hi is there a way to add a custom column in query editor and replicate this dax code Res = SWITCH(TRUE(), AND([Event Code]="Q3", [MarketSector]="Commercial"), "AW", AND([Researcher]<>"SLR", [Oper...
Need Help
Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Pandadev ,

 

It will be a simple IF AND ELSE condition. Something like below: (you can find many examples online)

 

 IF([Event Code]="Q3" AND [MarketSector]="Commercial") THEN "AW" ELSE IF ......

 

Thanks,

Pragati

Pandadev's avatar
Pandadev
Post Prodigy
5 years ago

I tried this but it shows an error on first AND , token comma expected

IF(
[Event Code]="Q3" AND [MarketSector]="Commercial") THEN "AW"
ELSE IF
[Researcher]<>"SLR" AND [OperatorTypeCode]="16") THEN "SLR" ))