2 Months Lagging Sales

[therightblue]

I need to create a measure that will calculate Gross Sales for the month that is 2 months previous to whatever Month I'm currently filtered by. 

I have a column for Gross Sales Product.

I have a column in my date table for 'Year-Month'

Ideally, I would need my 2021-01 Column to show $657,528.60.

[therightblue]

Thanks

[Shishir22 · Accepted solution]

Hello @therightblue ,

Please try below measure -

 

Previous = CALCULATE(SUM(Table1[GrossSalesProduct]),DATEADD('date'[Date],-2,MONTH))

If this solves the requirement, please mark it as a solution. Kudos are also appreciated!

Thanks