Nested IF Question?

Question

Hello All, I need some assistance with writing Nested If statement, I am trying to create a new column with the following if statement.&nbsp;IF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Category] = "Martial Arts "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THENIF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Sub Category] = "Boxing"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN "Boxing "&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSEIF&nbsp; [Sub Category] = "Karate"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN "Karate"&nbsp;&nbsp;&nbsp; END&nbsp;ELSEIF&nbsp; [Category] = "Sports"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN "Sports"ELSEIF&nbsp; [Category] = "Winter Sports"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN&nbsp;&nbsp;&nbsp; IF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Sub Category] = "Snowboarding"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN "Snowboarding"&nbsp;&nbsp;&nbsp; ELSEIF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Sub Category] = "Skiing"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN "Skiing"&nbsp;&nbsp;&nbsp; END&nbsp;&nbsp;I tried using Switch function and had no luck, does anyone has any suggestions?&nbsp;Thank you

alexisolson · Accepted Answer

I think SWITCH is a good idea.
&nbsp;
SWITCH (
    TRUE (),
    [Category] = "Martial Arts " &amp;&amp; [Sub Category] = "Boxing", "Boxing",
    [Category] = "Martial Arts " &amp;&amp; [Sub Category] = "Karate", "Karate",
    [Category] = "Sports", "Sports",
    [Category] = "Winter Sports" &amp;&amp; [Sub Category] = "Snowboarding", "Snowboarding",
    [Category] = "Winter Sports" &amp;&amp; [Sub Category] = "Skiing", "Skiing"
)

Forum Discussion

Nested IF Question?

2 Replies

Related content

Nested IF

Bookmark questions

Architecture question and brainstorming

Unpivot Question

Report Builder Nested SUM ( IIF Question