Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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?Table Structure.png

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/How-to-create-a-Pivot-table-on-calculated-column-Please-help-me/m-p/664505#M319528

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/How-to-create-a-Pivot-table-on-calculated-column-Please-help-me/m-p/664505#M319528

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not 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. 

Anonymous
Not applicable

Thanks but i can't use power query on dax calculated tables right?  If there is please show me!

 

 

Anonymous
Not applicable

Correct.  So I'd steer away from too many calculated columns and stick to creating measures for these figures. 

Anonymous
Not applicable

Thanks but that doesn't solve my issue as I need to unpivot this table to build a PandL.  Creating measures won't help me with the end goal of a PandL either.

Anonymous
Not applicable

Not sure I follow on why you feel you have to use calculated columns... Did a quick google search on p&l in power bi and came across this, maybe that could help you more than I can. 

https://www.youtube.com/watch?v=-jpYwz8-oYc

Anonymous
Not applicable

Thanks for trying to help but the video highlights exactly why i need to transform the calculated columns into accounts or "categories" (as highlighted in the video).

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.