Rolling Totals for the last month without Date context

Saurabh129 — Fri, 11 Nov 2022 14:04:30 GMT

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

Re: Rolling Totals for the last month without Date context

Anonymous — Fri, 11 Nov 2022 16:28:48 GMT

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

topic Rolling Totals for the last month without Date context in DAX Commands and Tips

Rolling Totals for the last month without Date context

Re: Rolling Totals for the last month without Date context