Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Syndicate_Admin
Administrator
Administrator

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thank you very much for the help.
With the video I am much clearer!!!

Thanks again.

Greg_Deckler
Super User
Super User

@Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thanks for answering, could you indicate how it could be done in power query??
Thanks in advance.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.