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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors