Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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"
)
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"
)
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |