Forum Discussion

AGo's avatar
AGo
Post Patron
6 years ago

Rolling sum optimization

Hello,   I populated a line chart with a cumulative function: Rolling count = SUMX(FILTER(ALLSELECTED(Tab[timestamp]),Tab[timestamp]<=MAX(Tab[timestamp])),CALCULATE(SUM(Tab[DeltaWithPreviousRowVa...
cumulative
DAX
rolling
amitchandak's avatar
amitchandak
Super User
6 years ago

AGo , a New column like

maxx(filter(Table, table[timestamp] <earlier(table[timestamp] )),table[timestamp]) -table[timestamp]

  • AGo's avatar
    AGo
    Post Patron
    6 years ago

    No, I'm sorry, the resulting value I need in my measure is not from timestamp column, it has to be extracted from calculations based on [vaue] or [DeltaWithPreviousRowValue] depending on which one is easier to use.