How to calculate the sum X months ago?

[VinhTon]

Calculate(  sum( value) ,previousmonth( date ) ) will give me last month but how do I pick before that? Like 3 months ago for example

[tackytechtom · Accepted solution]

Hi @VinhTon ,

How about this:

CALCULATE ( 
   SUM ( table[value] ),
   DATEADD(table[date], -3, MONTH)
) 

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ 

[VinhTon]

worked like a charm, thanks!

[fhill]

Here's a quick way.... (probably not the best way, that would be to define your Start and End Dates in a search or serach for a YYYYMM match on a Month Table?)

Calculate(  sum( value) ,previousmonth( DATEADD( date, -2, months) ) )