Unpivot Calculated Columns & Measures

[Anonymous]

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?

[v-juanli-msft]

Hi @Anonymous

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

Best Regards

Maggie