Forum Discussion
Solved
How to pivot with multiple values column?
I have data in the above format. I want to convert it in the format mentioned below: In excel I used to do it through sumifs, but that was really time consuming. I want to do it through ...
Hi himanshu23 ,
First go to query editor,select columns "Qreach,Qrem,Qsold">"unpivot columns",and you will get a table as below:
Then back to Report view,create a matrix,and you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
You could make that in a matrix visual, but are you sure you want to restructure your data? It is set up well for analysis now. Also, in the query editor, you won't be able to end up with the two columns with the same name.
Pat
I need to create reports in my organisation's format. I need to load it in excel only, that's how they want it.
