DAX Question - Calculated Column - 12 months prior per row

[Anonymous]

Hello!
I need to create a CALCULATED COLUMN that will bring back the total sales for the last 12 months,  per row, like this:

This is a simplified example, but It does need to be done for every row in a table as a calculated column 

Does anyone have any suggestions of where to start? Thank You!!

Alex

[amitchandak · Accepted solution]

@Anonymous , With a date table try formula like

example

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Thank You So Much!