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

[Anonymous]

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 😄 💙

[IEG · Accepted solution]

You can do it with SWITCH, try this,

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

)

[Anonymous]

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")