Unable to Unpivot Calculated Measures

[kanth452]

Hi Guys,

I created a few Measures and I would like to unpivot these. I can show you how they are visible now and i will also sow you guys how i want the table to be. Can you guys please help me in doing this? @Anonymous  Can I make a calculated table for this too

Current Scenario                                                                         

Metric	Value
Current Year M1	20
Prior Year M1	10
Current Year M2	38
Prior Year M2	25
Current Year M3	16
Prior Year M3	9

Expected Scenario

Metric	Current Year	Prior Year
M1	20	10
M2	38	25
M3	16	9

[Anonymous]

Please show the code of some measures and the current table structure.