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", [OperatorTypeCode]="16"), "SLR",
AND([Researcher]="SLR", [OperatorTypeCode]="16"), "SLR",
AND([Event Code]="21", [MarketSector]="Commercial" && [Manufacturer]<>"Bing"), "NF",
AND([Event Code]="61", [MarketSector]="Commercial" && [Manufacturer]<>"Bing"), "NF",
AND([Event Code]="71", [MarketSector]="Commercial" && [Manufacturer]<>"Bing"), "NF",
AND([Event Code]="81", [MarketSector]="Commercial" && [Manufacturer]<>"Bing"), "NF",
AND([Event Code]="21", [MarketSector]="Commercial" && [Manufacturer]="Bing"), "MB",
AND([Event Code]="61", [MarketSector]="Commercial" && [Manufacturer]="Bing"), "MB",
AND([Event Code]="71", [MarketSector]="Commercial" && [Manufacturer]="Bing"), "MB",
AND([Event Code]="81", [MarketSector]="Commercial" && [Manufacturer]="Bing"), "MB",
 
AND([Researcher]="", [Researcher]<>"JMY"), "ZZ",
 
[Researcher]
)
Need Help

6 Replies

    • Pandadev's avatar
      Pandadev
      Post Prodigy
      5 years ago

      Thanks I looked at that solution , but I need it to check two different criteria , which was not available in the conditional column

      in this example  below it is looking at Event Code =Q3 and MarketSector = Commercial , then change to AW

      AND([Event Code]="Q3", [MarketSector]="Commercial"), "AW",

      • 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