Rolling Totals for the last month without Date context

[Saurabh129]

I am trying to get the 12 month  Rolling Total Amount to show in a table where I dont have the date in the row context 

I have State or city dimention as row context
I just need the rolling totals for the last month  i.e.  Nov 2021 to Oct 2022

I need the sum of the total amounts for the last 12 months as one of the columns in the table below (column 6) 
irrespective of whatever date filters / slicers are picked 

can someone please help with this

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Saurabh129 - I believe that you mean that you want the previous 12 months of sales based on Today date.  Do you have a calendar table?  If so the following should work:

Rolling Last 12 Month Sales Amount =
VAR _EndDate = EOMONTH( TODAY(), -1)
RETURN
CALCULATE (
    [Sales Amount],
    DATESINPERIOD (
        'Date'[Date],
        _EndDate,
        -1,
        YEAR
    )
)