Rolling 12 month problem in a power bi matrix

[geiratatea]

Hi!

I am struggling on a power bi report displaying a matrix as you see below. The year-month slicer selects the yearmonths to be shown. But what I am really want is to use the date in the lowest left corner as an end date and from there show all 12 yearmonths back so I don't need to use the slicer. What I want is a measure slicer that gives me the date or YYYYMM range from in this case 202110 to 202011.

Now it works like this, I have to select from the periode slicer the YYYYMM and Distrikt, then I got RSPeriodeEnd field which the earliest is the one I want to use. This earliste RSPeriodeEnd must be easy to catch and then get all data 12 months back. A problem here is that there is a month table being used that connects to the fact table 

I have tried to expand the measure called Regnskap like this but it gives me rubbish in the matrix 😞

Regnskap 2 =

Var currentdate = TODAY() //this should be replaced by a min rsperiodeend date

RETURN

CALCULATE([Regnskap] + 0,

DATESINPERIOD ( 'Dim_Mnd'[LastDayOfMonth], currentdate , -12, MONTH )

)

I have looked at many pattern and have used all day on this, and I can't get the report do what I want. I hope you can help me and perhaps give a tip or two or maybe some dax code to solve this.

Hope to hear from you

regards Geir

NB! Is it possible to add a column to a matrix like the YYYYMM but have some other data in that column? Perhaps through a calculated table union function??

[amitchandak]

@geiratatea , try measure like

//Last 12 based on today
new measure =
var _max = eomonth(today(),0)
var _min = eomonth(today(),-12)+1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

hope you have date table and it is not filtered

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