Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 😄 💙
Solved! Go to Solution.
You can do it with SWITCH, try this,
SWITCH (
[Country],
Italy, "Europe",
Germany, "Europe",
Spain, "Europe",
)
You can do it with SWITCH, try this,
SWITCH (
[Country],
Italy, "Europe",
Germany, "Europe",
Spain, "Europe",
)
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")
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |