Forum Discussion

Jordan11257's avatar
Jordan11257
New Member
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • Jordan11257's avatar
      Jordan11257
      New Member
      5 years ago

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