topic Re: Nested if statment with IN claus in DAX Commands and Tips

Nested if statment with IN claus

DebbieStubbs67 — Thu, 16 Feb 2023 12:55:42 GMT

Iif i have a column with a list of codes, (eg A01, A02,A03, B01, B02, B03, C01, C02,C03), How would i create a sutom colum like

if code in A01, A02,A03 then A Group

if code in B01, B02, B03 then B Group

if code in C01, C02,C03) then C Group

I am not sure of the syntaax, In SQL I would use a case statement and in cluases, but cant work out the syntx for power BI

therefore making

codes New Column

A01 A Group

A02 A Group

A03 A Group

B01 B Group

B02 B Group

B03 B Group

C01 C Group

C02 C Group

C03 C Group

Re: Nested if statment with IN claus

tamerj1 — Thu, 16 Feb 2023 13:24:23 GMT

Hi DebbieStubbs67
Hard coded method would be

New Column = SWITCH ( TRUE (), 'Table'[Code] IN { "A1", "A2", "A3" }, "A Group", 'Table'[Code] IN { "B1", "B2", "B3" }, "B Group", 'Table'[Code] IN { "C1", "C2", "C3" }, "A Group" )

Other dynamic methods could also be possible but requires real examples.

Re: Nested if statment with IN claus

DebbieStubbs67 — Thu, 16 Feb 2023 20:30:13 GMT

That is Spot on, Just what I need, Many Thanks