Forum Discussion

KevinColes's avatar
KevinColes
Icon for Helper III rankHelper III
5 years ago

Show columns and values on rows in same matrix

Hi experts, I am wondering if anyone knows if this is possible or how to do it. I am building a Work In Process (WIP) report based off of ERP data that includes Aging columns for the Unbilled amou...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

the easiest thing to do is anonymise some of your data and provide a small sample.  That way it would be easy to work it out.  However In power query i would think it quite simple to unpivot the measures that you currently have into a different structure.

Power query challenge -Unpivot complex tables solution

https://www.youtube.com/watch?v=l8eh6uOYa0g