Forum Discussion
P_D_G
5 years agoResolver III
Pivot table based on multiple values / rows to columns
Hi all, I have the below dataset and I'd like to have it in a new format (2nd table). I've already created this in Power Query by pivoting the table in 2 separate queries: 1) pivot based on ...
- Anonymous5 years ago
Hi P_D_G ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
Anonymous
5 years agoNot applicable
Hi P_D_G ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
P_D_G
5 years agoResolver III
Semms good, thanks for the idea! So it's still a lot of clicks but at least don't have to worry about multiple tables, good stuff.