Forum Discussion

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    If you want cumulative

    This need row context to need to be in filter and in max

    cumulated hours =
    CALCULATE(
    [Hours] ,
    ALLSELECTED( 'calendar' ), filter('calendar'[week num] <=max('calendar'[week num]))
    )