Forum Discussion
Athena_Liu
8 years agoNew Member
Prepare data in PowerBI - long table
Hi Masters,
I have problem with preparing my data for PowerBI, the table I have put the dates(every week) in the column names together with staff name, client name, as shown below:
I want to view the number of hours that oe staff worked for one client change with time.
I need to convert the format to something like this in PowerBI, because i couldn't modify the original Excel tables:
Any Ideas? Really appreciate your help!!!!
Thank you!
1 Reply
- v-piga-msft
Resident Rockstar
Hi Athena_Liu,
For your scenario, you could try to Unpivot Columns under Transform in the Power Query Editor like below.
For further, you could have a reference of Pivot and Unpivot with Power BI.
Best Regards,
Cherry