Sum up to current month

[kasife]

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]))

[Priya1969 · Accepted solution]

Hi,

Use this calculation:

Max sales2 = CALCULATE(SUM(Sheet2[Sales]),FILTER(Sheet2, Sheet2[Date] <= EOMONTH(NOW(),-2)+1))

Output:

[kasife]

@Priya1969 Its worked perfectly. Thaniks so much