Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago
Solved

Sum up to current month

Hi Guys,
I'm doing the sum of sales considering project and module, but I need to consider only sales that were made up to the month before the current one. How could I do this?

 

This is the formula I'm using

 

Total repasses por produto = 

    CALCULATE(
        [_Qtde Repasses Realizados],
        ALLEXCEPT(f_reaal_realizado,f_reaal_realizado[Nome do Projeto Original],f_reaal_realizado[Módulo]))

 

 

Need Help
  • Priya1969's avatar
    Priya1969
    3 years ago
    Hi,
    Use this calculation:
     
    Max sales2 = CALCULATE(SUM(Sheet2[Sales]),FILTER(Sheet2, Sheet2[Date] <= EOMONTH(NOW(),-2)+1))
     
    Output:

     

2 Replies

  • Priya1969's avatar
    Priya1969
    Icon for Resolver I rankResolver I
    3 years ago
    Hi,
    Use this calculation:
     
    Max sales2 = CALCULATE(SUM(Sheet2[Sales]),FILTER(Sheet2, Sheet2[Date] <= EOMONTH(NOW(),-2)+1))
     
    Output: