Forum Discussion

bbbt123's avatar
bbbt123
Icon for Helper I rankHelper I
6 years ago
 
 

 

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

Forgot table in filter

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

 

Appreciate your Kudos.

 

  • bbbt123's avatar
    bbbt123
    Icon for Helper I rankHelper I
    6 years ago

     

     

    • v-eachen-msft's avatar
      v-eachen-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi bbbt123 ,

       

      Your formula seems to be correct, maybe it is a data issue?

      Please check if your No.11 week's data is correct. Or is the "Hours" column determined by the calculation formula?