Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
I need to group/combine row variables into a specific category type. For example;
I have a column called industry category where I have row variables captured as "Supermarket/Supermarkets/SuperMkts" for three different businesses. But they are part of the same industry type. I would like to group them as "Supermarkets" so that I can visualise my data in the correct format. Now I can group them by right-clicking on the column and select "New Group". It's a cumbersome task when I need to do a similar exercise for 20k line items. I was wondering if there is a way to automate this process by writing a dax code or in power query!
I am unable to find a solution. It would be great if you could help me with this.
Thanks in advance
Regards
ronie
Solved! Go to Solution.
Hi @Anonymous
Bestway is create lookup table like below and create calculated column
In future if you want to add new values, you can simply update this lookup table.
Create calculate column
Hi @Anonymous
You can create a calcualted column like below
Hello @gvrajesh,
Thank you for your reply. I can certainly apply your logic to search a specific keyword. Unfortunately, I have plenty to look for. Can I add multiple search rules in single containsstring function? I was thinking of this way;
Hi @Anonymous
Bestway is create lookup table like below and create calculated column
In future if you want to add new values, you can simply update this lookup table.
Create calculate column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |