Forum Discussion

Athena_Liu's avatar
Athena_Liu
New Member
8 years ago

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. 

 

Capture1.PNG


I need to convert the format to something like this in PowerBI, because i couldn't modify the original Excel tables:

 

Capture.PNG

 

Any Ideas? Really appreciate your help!!!!

Thank you!