Cumulative SUM with date filter

[Anonymous]

Hello,

I am having an issue that I can't seem to figur out.

I need a cumulative SUM but only since a certain date.

Calculated Column= CALCULATE(SUM(Column), ALL('Table'),'Table'[Date]<= EARLIER('Table'[Date]))

I need to add another filter that only does this calculated column when date >= 2021/01/01 

How can this be done?

Thanks a lot!

[Angith_Nair]

Hi @Anonymous ,
You can try this measure..

Column =
CALCULATE (
    SUM(Column),
    ALL ( 'Table' ),
    'Table'[Date] <= EARLIER ( 'Table'[Date] ),
    'Table'[Date] >= DATE(2021,01,01)
)

[amitchandak · Accepted solution]

@Anonymous , Try like

Calculated Column= SUMX(Filter('Table','Table'[Date]<= EARLIER('Table'[Date]) && 'Table'[Date] > date(2021,01,01)), [Column])

[Anonymous]

Have one question, if you're able to answer please.

Why doesn't it work for the opposite situation, so

< date(2021,01,01) instead of >date(2021,01,01)

[Anonymous]

That works for me!
Thank you so much