Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative SUM with date filter

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]<= ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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)