Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Cumulative total between two selected dates

Hello You would need to calculate the total accumulated by months and years of a value but that is between two segmented dates (start and end) and that when the year changes it starts from 0. ...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Syndicate_Admin ;

    You could try it.

    Cumulative measure =
IF (
    ISINSCOPE ( 'Sheet1'[Year] ),
    CALCULATE (
        SUM ( Sheet1[Value] ),
        FILTER (
            ALL ( Hoja1 ),
            Hoja1[Fecha_A] <= MAX ( Hoja1[Fecha_A] )
                && Sheet1[Year] = MAX ( Sheet1[Year] )
        )
    ),
    SUM ( Sheet1[Value] )
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Syndicate_Admin ;

You could try it.

Cumulative measure =
IF (
    ISINSCOPE ( 'Sheet1'[Year] ),
    CALCULATE (
        SUM ( Sheet1[Value] ),
        FILTER (
            ALL ( Hoja1 ),
            Hoja1[Fecha_A] <= MAX ( Hoja1[Fecha_A] )
                && Sheet1[Year] = MAX ( Sheet1[Year] )
        )
    ),
    SUM ( Sheet1[Value] )
)


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.