Rolling 12 Month Sales based on current month

Anonymous · ‎02-10-2020

Hello,

Is there a way to display sales for the previous 12 months using the current month as context? For example, using February as the month in question, I would like to see sales between Mar 2019 - Feb 2020 as well as Mar 2018 - Feb 2019 and Mar 2017 - Feb 2018 and so on.

I want to plot this by year, so the visual would show 2017, 2018, 2019, 2020, etc. The sales displayed per year would be the prior 12 month sales for each respective current month (so February for each year).

Anonymous · ‎02-10-2020

Hi @Anonymous ,

Please make a new MEASURE to calculate sumof sales from last 12 Month as follow :

NewColumn =
VAR Last_12Month =
    MONTH ( TODAY () - 330 )
RETURN
    CALCULATE (
        sum_sales,
        DATESBETWEEN ( 'Table'[Date].DATE, Last_12Month, TODAY () )
    )

Please change Value 330 according to yoyr requirement.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.

Regards,

Gaurav Raj Singh

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/