Forum Discussion

ShemRo's avatar
ShemRo
Regular Visitor
4 years ago
Solved

Cumulative Sum not working??

Hi There, I have the below dataset. I am wanting to calculate a cumulative total of the act column. I am making a mistake in my calculated column somwhere in the code: Cumulative_Act_Hours_C...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Oh Ok.

    Have you tried this:

    Cumulative_Act_Hours_Col =
    CALCULATE(
    SUM( 'Table'[act] ),
    FILTER( ALL( 'Table' ), 'Table'[MonthYear] <= EARLIER( 'Table'[MonthYear] ) )
    )

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi ShemRo 

 

What is your "MonthYear" column format? it seems it's not date/time!

Check that and then if it's not Date format change that to Date format and check your formula again.

 

Cumulative_Act_Hours_Col = CALCULATE(SUM('Table'[act]),Filter(All('Table'),'Table'[MonthYear]<=EARLIER('Table'[MonthYear])))

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

  • ShemRo's avatar
    ShemRo
    Regular Visitor
    4 years ago

    That it what i orginally thought too but...

    regards Shem

    • VahidDM's avatar
      VahidDM
      Super User
      4 years ago

      Oh Ok.

      Have you tried this:

      Cumulative_Act_Hours_Col =
      CALCULATE(
      SUM( 'Table'[act] ),
      FILTER( ALL( 'Table' ), 'Table'[MonthYear] <= EARLIER( 'Table'[MonthYear] ) )
      )

       

      If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
      Appreciate your Kudos!!
      LinkedIn:       www.linkedin.com/in/vahid-dm/

       

       

      • ShemRo's avatar
        ShemRo
        Regular Visitor
        4 years ago

        Ahh yes!!! Thanks so much. This got it. it was the 'Table' after the ALL that i had incorrect.

         

        Thank you so much!!