Dynamic (very!) column headers in matrix

[AnetaK]

Hello,

I have an issue with column headers in matrix.

I need to show 12 months - dynamicly changed.

That is not a big issue - I can use a month name from the calendar as a column.

But there are two more requirements:

1. I have to add some other measures to the matrix,

2. These 12 month have to be dynamically changed by the slicer - so if I select September, then I want to see Sep and 11 prevoius months, if I select May, then May would be the first one and then 11 previous months.

What I did (as the only solution I found) - I created separate measures for each column and added additional cards with dynamic headers to cover the matrix headers.

It worked when I didn't touch the matrix.

But I can go up and down the 4-level hierarchy - and then the allignment is not working anymore.

I should have dynamic headers as a regular part of the matrix.

Any idea what can be done?

[AnetaK]

I already have two separate calendar tables, measure is not an issue.

Issue is how to change column names.

[amitchandak]

@AnetaK , Create slicer on an independent date table, then you can have measure like

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI