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!

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!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors