Forum Discussion

therightblue's avatar
therightblue
Frequent Visitor
5 years ago
Solved

2 Months Lagging Sales

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.

 

 

Need Help
  • Shishir22's avatar
    Shishir22
    5 years ago

    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

2 Replies

  • Shishir22's avatar
    Shishir22
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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