topic Re: Can I transpose Measures/columns that I have created using DAX? in DAX Commands and Tips

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

jamdale97 — Mon, 01 Feb 2021 15:38:26 GMT

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 — Mon, 01 Feb 2021 16:44:19 GMT

jamdale97 — Mon, 01 Feb 2021 17:33:08 GMT

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?