Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I would like to create a calculated column using IF. I am not sure how to use multiple Logical test.
For eg:
I have a set of locations. And each location belong to a certain region. It looks something like the image below.
I want to create a calculated column called "Region" in PowerBI, where it checks what location and allot the particular region.
Can I please know how can I implement that?
Any help would be appreciated!
Thank you!
Megha
Solved! Go to Solution.
Hi @Anonymous ,
You can try below code:-
Region =
IF (
LOCATION[Location] IN { "PL60", "MA81", "MA82" },
"EMEA",
IF ( LOCATION[Location] IN { "2201" }, "APAC", "NA" )
)
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
Hi @Anonymous ,
You can try below code:-
Region =
IF (
LOCATION[Location] IN { "PL60", "MA81", "MA82" },
"EMEA",
IF ( LOCATION[Location] IN { "2201" }, "APAC", "NA" )
)
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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |