Forum Discussion
Unpivot table with calculated DAX columns
Hi there,
I have a table that has many calculated DAX tables so I can't do this in powerquery, I guess i could extract the table into csv then unpivot it but it would seem like there is a better way to do this?
Below is a view of the table structure, I would like the Application Cost, Telesales cost etc to be stacked like accounts so that i can build a P&L. any suggestion on how to do this elegantly?
Anonymous
You may take a look at the post below.
7 Replies
- AnonymousNot applicable
You can use the unpivot function in Power Query, though you would probably be better served just creating measures with those values so you dont have to load them, plus measures would be much more dynamic.
- AnonymousNot applicable
Thanks but i can't use power query on dax calculated tables right? If there is please show me!
- AnonymousNot applicable
Correct. So I'd steer away from too many calculated columns and stick to creating measures for these figures.
- v-chuncz-msftCommunity Support
Anonymous
You may take a look at the post below.