Forum Discussion
Advocate IIIhow to get report from multi-dimensional data in Excel sheet?
well I just realised it was going to take me half an hour to type up the instructions on how to do this (one way anyway), and 5 mins to record a video. So here is a video. I hope I have correctly interpreted what you are trying to do.
BTW, Power Query is awesome
https://www.dropbox.com/sh/b4mug9j96xp0j7e/AABo0fXptDaQT2ifBbBggYyfa?dl=0
Advocate IIIOh, sorry - completely forgot :)
Here is the link to the sample file (I somehow don't see where can I attach file to my post...)
Community Championwell I just realised it was going to take me half an hour to type up the instructions on how to do this (one way anyway), and 5 mins to record a video. So here is a video. I hope I have correctly interpreted what you are trying to do.
BTW, Power Query is awesome
https://www.dropbox.com/sh/b4mug9j96xp0j7e/AABo0fXptDaQT2ifBbBggYyfa?dl=0
- prokurors
Thanks! I managed to repeat these tasks in Power BI Desktop!