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.
I have about 100 salespeople in one column, I have to group them into new column by label them "MFG" and "FSI"
What is the most effective way to do this? Use DAX?
Creating a conditional column is tedious in this case.
Solved! Go to Solution.
@Anonymous , You have to create conditional column using if ow switch - https://www.youtube.com/watch?v=gelJWktlR80
also refer: https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
@amitchandak many thanks for the quick solution. It solved my main problem. However, one issue remains.
In this column, I have 100 sales people, where 10 belong to "MFG", another 10 belong to "FSI" and rest of 80 sales people belong to "General".
For the MFG and FSI grouping, I used your instruction on youtube and it worked well.
but for the rest of 80 people, is there any expression to group them using minimal formula. Want to avoid putting 80 names in this expression 🙂 Thanks
@Anonymous , You have to create conditional column using if ow switch - https://www.youtube.com/watch?v=gelJWktlR80
also refer: https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |