Can I transpose Measures/columns that I have created using DAX?

[jamdale97]

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

[Greg_Deckler · Accepted solution]

@jamdale97  - See if you can use this: https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314

[jamdale97]

@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?