Rolling 12 month sum

[sabd80]

Hi,

I would like to calculate the measure Rolling 12 Month Spend.

I need this measure by month, the figure of each month should be (current month + the previous 11 months).

For example, row 13 should be the sum of B2 to B13, row 14 should be the sum of B3 to B14 and so on, the silcer should not change this calculation.

[Ashish_Mathur]

Hi,

PBI file attached,

Hope this helps.

[sabd80]

Thanks @Ashish_Mathur , but it is showing the just the monthly amount.

I think the problem is the calendar table is not a date table.

[Ashish_Mathur]

You have obviously not chacked the file that i uploaded.  Study that carefully.

[sabd80]

I have, and I have used the DAX you have provided before, so it is not new.

I am not sure what do you mean by Study that carefully.

[Ashish_Mathur]

As you can see in the screenshot, my solution is working fine.  I do not know the mistake that you are committing in your file.  Check the relationship.

[sabd80]

this is my measure:

Testing Rolling 12 ALL =

CALCULATE (

      [Total Spend $],

      DATESBETWEEN('Calendar - Invoice Date'[Calendar Date],          

        EDATE( MIN ( 'Calendar - Invoice Date'[Calendar Date]), -11 ) ,

        MAX ( 'Calendar - Invoice Date'[Calendar Date] )              

      )

)

and the relationship is the same as your

[Ashish_Mathur · Accepted solution]

Share the download link of the PBI file.