Show data for the last 12 months on a matrix table

[Lancelot]

Hi All

I have a matrix which shows the current selected totals for the segment as well as last year same period value. i.e If I pick January 2023, I am able to see January 2022. However, I am trying to also show to tals for the last 12 months on the same matrix.

Please see below table. I have tried using a calendar table with no luck. Please assist.

[amitchandak · Accepted solution]

@Lancelot , if you select 1 period and want to display more than one period then use an independent date table in slicer

//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