Rolling 12 months sum for completed months

[Chinoos]

I'm struggling to get rolling 12 months for the months that are completed. For example; For the current month the value should display Zero and for the completed months it should display rolling 12 months values. For 2016-Dec the value=sum(2016-Jan till 2016-Dec), 2016-Nov=sum(2015-Dec till 2016-Nov)

Year	Month	Value
2016	8	985193929.9
2016	9	985428542.2
2016	10	985365989.1
2016	11	992519096.7
2016	12	980109375.8
2017	1	0

Please suggest any idea, if you have come across the same

[Chinoos]

I'm struggling to get rolling 12 months for the months that are completed. For example; For the current month the value should display Zero and for the completed months it should display rolling 12 months values. For 2016-Dec the value=sum(2016-Jan till 2016-Dec), 2016-Nov=sum(2015-Dec till 2016-Nov)

Year	Month	Value
2016	8	985193929.9
2016	9	985428542.2
2016	10	985365989.1
2016	11	992519096.7
2016	12	980109375.8
2017	1	0

Please suggest any idea, if you have come across the same

[v-sihou-msft · Accepted solution]

@Chinoos

I assum you already have your table link to another full calendar table. You can try formula like below:

[Rolling 12 months total value] =
CALCULATE(Table[value], 
          DATESINPERIOD(Calendar[Date], 
                        LASTDATE(Calendar[Date]),-12, Month
                       )
         )

Regards,

[PavelR]

@Chinoos I recommend this post on SQLBI.

Regards.

Pavel