Rolling 12 month sales over a Financial year

[Anonymous]

Hi

I'm really stumped on creating a DAX measure for this calculate, it appears to be really simply but I'm really struggling. I need to calculate rolling/accumaltive sales over a financial year which starts Sept -Aug.  I do not want to include the sales from any other previous years.  

Here's an example of the data from excel and it's the Rolling FY year total I need to calculate.  In my report I have a FY slicer so I will need to be able for flip between financial years.  I do help someone can help.  Kind regards  Jo

MONTH	Sales By Month	Rolling FY Yearly Total
Sep-16	£1,450,156.00	£  1,450,156.00
Oct-16	£874,019.00	£2,324,175.00
Nov-16	£1,063,685.00	£3,387,860.00
Dec-16	£774,785.00	£4,162,645.00
Jan-17	£856,423.00	£5,019,068.00
Feb-17	£792,407.00	£5,811,475.00
Mar-17	£979,384.00	£6,790,859.00
Apr-17	£763,471.00	£7,554,330.00
May-17	£833,589.00	£8,387,919.00
Jun-17	£765,367.00	£9,153,286.00
Jul-17	£881,125.00	£10,034,411.00
Aug-17	£856,355.00	£10,890,766.00

[TomMartens · Accepted solution]

Hey,

almost everything that is related to time can be found here

daxpatterns.com/time-patterns

Hopefully this gets you started

Regards

Tom

[Anonymous]

thank you @Anonymous this link is extremely useful

[TomMartens]

😉 indeed it is