cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aitenlabs
Regular Visitor

IF string equals A, or B, or C, then D

Hi all, I am pretty new to DAX, and I have been stuck on an IF statement since this morning. 

 

The problem is I have a list of countries as strings. I want to group them, using a new column, into continents.

For instance:

IF [country] = "Italy", "Europe".

and this line works pretty well. The problem is I would like to specify also other nations. I don't want to create endless IF statements, you know. XD

 

So I think I need something like that:

IF [country] = "Italy", "Germany", "Spain", then "Europe"

Thanks for any help you can give me. Also, if there are better solutions, my ears are open 😄 💙

 

 

1 ACCEPTED SOLUTION
IEG
Frequent Visitor

You can do it with SWITCH, try this,

 

SWITCH (
[Country],
Italy, "Europe",
Germany, "Europe",
Spain, "Europe",

)

 

View solution in original post

2 REPLIES 2
IEG
Frequent Visitor

You can do it with SWITCH, try this,

 

SWITCH (
[Country],
Italy, "Europe",
Germany, "Europe",
Spain, "Europe",

)

 

View solution in original post

aitenlabs
Regular Visitor

Many thanks! Your solution is exactly what I was looking for. I started to write something like the code I've placed below, but it's a complete waste of time! Your solution is definitely better!

Have a lovely day,
Ernesto.

calc_continents = 

IF(

CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Austria")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Belgium")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Bulgaria")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Croatia")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Cyprus")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Czechia (Czech Republic)")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Denmark")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Estonia")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Finland")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "France")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Germany")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Greece")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Hungary")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Ireland")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Italy")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Latvia")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Lithuania")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Luxembourg")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Malta")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Netherlands")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Poland")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Portugal")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Romania")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Slovakia")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Slovenia")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Spain")

|| CONTAINSSTRING( 'pub?gid=137090910&single=true&output=csv'[country], "Sweden"),

"Europe")

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.