Forum Discussion
passing columns to rows
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.
Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX
4 Replies
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.
