Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, I have the following problem.
I have a single table which has many records and the situation that arises is the following:
user id area
1 management frameworks
2 pepe management
1 frame system
in this simple example you can see that a user can be assigned to more than one area, what I want to achieve is to leave it as follows:
user id area
1 frameworks administration, system
2 pepe management
Is it possible to do that? Could you please help me?
Thanks a lot.
Solved! Go to Solution.
@Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX
Thank you very much for the help.
With the video I am much clearer!!!
Thanks again.
@Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX
Thanks for answering, could you indicate how it could be done in power query??
Thanks in advance.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
106 | |
93 | |
69 |
User | Count |
---|---|
167 | |
132 | |
130 | |
96 | |
91 |