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...
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

therightblue's avatar
therightblue
Frequent Visitor
5 years ago

Thanks