Forum Discussion
kanth452
7 years agoNew Member
Unable to Unpivot Calculated Measures
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 |
1 Reply
- AnonymousNot applicable
Please show the code of some measures and the current table structure.