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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jordan11257
New Member

Reordering data

Hi my current dataset that I get in Power BI looks like this :

ProjectMember
SAP SSOMartin
SAP SSOStefan 
SAP SSOTom
SAP SSOSteve
IT-ServiceMartin
IT-ServiceSteve
Customer ProjectMartin
Customer ProjectTom
Customer ProjectSteve

For better usage I would like to create a new table (with DAX function?) to align ist like that

ProjectMember 1Member 2Member 3Member 4
SAP SSOMartinStefanTomSteve
IT-ServiceMartinSteve  
Customer ProjectMartinTomSteve 

 

Is this possible and could anybody pls help me? Thank you very much


2 REPLIES 2
Anonymous
Not applicable

Use Power Query. Add a column to the data to say which row is which member (Member1, Member2,...) and then use the Pivot operation to get exactly what you want.

My original table has over 1000 rows and every project has a different amount of employees envolved. Isnt there an easier solution?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors