Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have two columns User and Region, I want to create a custom column that can categorize the data under specific column called 'group' as highlighted in Blue.
so basically I should have allusers categorized in two groups Emea@test.com and Eu@test.com
I want to write a DAX which can categorize the below data in column 'Group' .Please suggest if this can be handled using any DAX..
Expected result :-
User | Region | Group |
A | EMEA | Emea@test.com |
B | EMEA | Emea@test.com |
C | EMEA | Emea@test.com |
D | EMEA | Emea@test.com |
E | EUROPE | Eu@test.com |
F | EUROPE | Eu@test.com |
G | EUROPE | Eu@test.com |
Input source :-
User | Region |
A | EMEA |
B | EMEA |
C | EMEA |
D | EMEA |
E | EUROPE |
F | EUROPE |
G | EUROPE |
Solved! Go to Solution.
Hi, @deb_power123
I am not sure if I understood your question correctly, but please check the below picture and the formula for creating a new column.
Group CC =
SWITCH ( 'Table'[ Region], "EMEA", "Emea@test.com", "EUROPE", "Eu@test.com" )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @deb_power123
I am not sure if I understood your question correctly, but please check the below picture and the formula for creating a new column.
Group CC =
SWITCH ( 'Table'[ Region], "EMEA", "Emea@test.com", "EUROPE", "Eu@test.com" )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Perfect sir 🙂
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |