How to get rolling 12 month sum in PowerBI

Question

I want to create a sum of 12 months' sales from last month of my date column.

and I had 3 years from 2016 to 2018 and I want to refresh the dashboard monthly by adding next month

How can I able to do it

Answer 1

I had a code

Rolling 12 Month Total :=
CALCULATE (
    SUM ( 'Table'[Sales] ),
    DATESBETWEEN (
        'Date'[Date],
        NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Date'[Date] ) ) ),
        LASTDATE ( 'Date'[Date] )
    )
)

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.