Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Unpivot Calculated Columns & Measures

Hello, I am creating a projected P&L based on sales that are active and have not closed yet to compare to the P&L I get for business closed from prior months.  My table has about half the columns that I can easily unpivot but the other half of the data are calculated columns and measures that I need to unpivot and cannot find a way to do that.  If I cannot do that I will have to edit my query and create the columns all over again in query editor to allow me to unpivot the rest of the data but I don't want to go through doing all the work that I already have done.  I have tried using the matrix visual and "show on rows" but the problem with that is that I cannot group fields and it will not total all the columns when I "show on rows" the way it would have if I could have unpivot the data, group it, and have it automatically total the values.  Any ideas?



Community Support
Community Support

Re: Unpivot Calculated Columns & Measures

Hi @pwhite

Could you show me example of your data model and expected result so that I can provide better and detailed solution?


Best Regards


Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors