Forum Discussion

Icon for Post Prodigy rank

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...

Pragati11
5 years ago
Hi Pandadev ,

Your closing brackets are wrong.

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

There is a nice example on the following blog:
https://www.fourmoo.com/2018/11/27/multiple-conditions-for-a-conditional-column-in-power-query/

Thanks,

Pragati

Icon for Post Prodigy rank

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" ))

Icon for Super User rank

Super User

5 years ago

Your closing brackets are wrong.

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

There is a nice example on the following blog:
https://www.fourmoo.com/2018/11/27/multiple-conditions-for-a-conditional-column-in-power-query/

Thanks,

Pragati

Pandadev
Post Prodigy
5 years ago
Thanks for the example , I have now managed to get it to work