topic Re: Reordering data in DAX Commands and Tips

Reordering data

Jordan11257 — Wed, 25 Nov 2020 10:24:42 GMT

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

Project	Member
SAP SSO	Martin
SAP SSO	Stefan
SAP SSO	Tom
SAP SSO	Steve
IT-Service	Martin
IT-Service	Steve
Customer Project	Martin
Customer Project	Tom
Customer Project	Steve

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

Project	Member 1	Member 2	Member 3	Member 4
SAP SSO	Martin	Stefan	Tom	Steve
IT-Service	Martin	Steve
Customer Project	Martin	Tom	Steve

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

Re: Reordering data

Anonymous — Wed, 25 Nov 2020 10:41:07 GMT

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.

Re: Reordering data

Jordan11257 — Wed, 25 Nov 2020 10:53:17 GMT

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