topic Re: Nested IF Question? in DAX Commands and Tips

Nested IF Question?

Anonymous — Tue, 08 Feb 2022 14:56:08 GMT

Hello All, I need some assistance with writing Nested If statement, I am trying to create a new column with the following if statement.

IF [Category] = "Martial Arts " THEN

IF [Sub Category] = "Boxing" THEN "Boxing "

ELSEIF [Sub Category] = "Karate" THEN "Karate"

END

ELSEIF [Category] = "Sports" THEN "Sports"

ELSEIF [Category] = "Winter Sports" THEN

IF [Sub Category] = "Snowboarding" THEN "Snowboarding"

ELSEIF [Sub Category] = "Skiing" THEN "Skiing"

END

I tried using Switch function and had no luck, does anyone has any suggestions?

Thank you

Re: Nested IF Question?

Samarth_18 — Tue, 08 Feb 2022 15:05:19 GMT

Hi Anonymous ,

You can use below code:-

Measure = IF ( [Category] = "Martial Arts ", IF ( [Sub Category] = "Boxing", "Boxing", IF ( [Sub Category] = "Karate", "Karate", IF ( [Category] = "Sports", "Sports", IF ( [Category] = "Winter Sports", IF ( [Sub Category] = "Snowboarding", "Snowboarding", IF ( [Sub Category] = "Skiing", "Skiing" ) ) ) ) ) ) )

Thanks,

Samarth

Re: Nested IF Question?

AlexisOlson — Tue, 08 Feb 2022 18:18:50 GMT

I think SWITCH is a good idea.

SWITCH ( TRUE (), [Category] = "Martial Arts " && [Sub Category] = "Boxing", "Boxing", [Category] = "Martial Arts " && [Sub Category] = "Karate", "Karate", [Category] = "Sports", "Sports", [Category] = "Winter Sports" && [Sub Category] = "Snowboarding", "Snowboarding", [Category] = "Winter Sports" && [Sub Category] = "Skiing", "Skiing" )