Switch levels of double header matrix

[looraainne]

I have a matrix with a bunch of measures as values. I want to divide it by month and I am able to, just not in the format I need. currently I have something like this one on my matrix. I put the month in the columns field and all the measures in the values field.

	Jan	Jan	Jan	Jan	Jan	Feb	Feb	Feb	Feb	Feb
	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5
item1
item2
item3
item4

I want my matrix to look like this:

	Measure 1	Measure 1	Measure 2	Measure 2	Measure 3	Measure 3	Measure 4	Measure 4	Measure 5	Measure 5
	Jan	Feb	Jan	Feb	Jan	Feb	Jan	Feb	Jan	Feb
item1
item2
item3
item4

I am able to do this easily on pivot tables on excel because an extra field on on the columns field appears representing everything in the values field  but I can't seem to find an equivalent function on power BI.

[amitchandak]

@looraainne , the calculation group can help

refer to my video for that

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[looraainne]

HI @amitchandak Thanks for your reply!

currenty trying to follow your video, it looks like it has exactly what I need. I am running into this error, I tried to follow the logic with my own naming convention but I am receiving this error. I can't find what I am doing wrong here