Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Is there a way that I can transpose Measures/columns within a table that I have created using DAX?
For example:
Month | Number of Unemployed | Month-on-Month Change in Number of Unemployed (DAX) | Month-on-Month % Change in Number of Unemployed (DAX) |
October 20 | 670 | 25 | 4% |
November 20 | 675 | 5 | 1% |
December 20 | 670 | -5 | -1% |
January 21 | 665 | -5 | -1% |
Can I transpose this to:
Month | Oct-20 | Nov-20 | Dec-20 | Jan-21 |
Number of Unemployed | 670 | 675 | 670 | 665 |
Month-on-Month Change in Number of Unemployed (DAX) | 25 | 5 | -5 | -5 |
Month-on-Month % Change in Number of Unemployed (DAX) | 4% | 1% | -1% | -1% |
I would be very grateful for any suggestions anybody has.
Many thanks
Solved! Go to Solution.
@jamdale97 - See if you can use this: https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314
@jamdale97 - See if you can use this: https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314
@Greg_Deckler Thank you for your reply, although I am a bit lost. Is this solution mainly for 4x4 tables, as my table is larger than that?
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |