Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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?

7 Replies