Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

)

 

Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors