Forum Discussion

RHerrera's avatar
RHerrera
Frequent Visitor
7 years ago
Solved

Calculated cumulative column with a complication

Hi, I have been trying to get cumulative values in a calculated column but I couldn't find a way to re-start the cumulative calculation once there is a change from Q1 to Q2 to Q3 (Q=quarter of a day)...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    RHerrera

     

    try this one

     

    =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, [Q] = EARLIER ( [Q] ) && [Time] <= EARLIER ( [Time] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

RHerrera

 

try this one

 

=
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, [Q] = EARLIER ( [Q] ) && [Time] <= EARLIER ( [Time] ) )
)
RHerrera's avatar
RHerrera
Frequent Visitor
7 years ago

Thank you very much, I was really close but you got it!