Forum Discussion

webportal's avatar
webportal
Impactful Individual
10 years ago
Solved

Create a running total using TOTALYTD

How can I create a running total using a measure with formula TOTALYTD?

 

In the formula below, Turnover YTD is using exactly the same fields in the matrix:

 

  • Faturação (Turnover in english)
  • Dia (Day)

Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    10 years ago

    Yes you are right. The value in the rows/columns should always be coming from the lookup table.

     

    Hope it helped you to gain the understanding of DAX.

7 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    10 years ago
    Running Total:=CALCULATE (
        SUM ( Table[Column] ),
        FILTER (
            ALL ( 'Date'[Date] ),
            'Date'[Date] <= MAX ( 'Date'[Date] )
        )
    )
    • webportal's avatar
      webportal
      Impactful Individual
      10 years ago

      Hi,

      Thanks a lot for helping!

      That should work, but it is returning exactly the same result.

       

      Also, what is wrong in my formula?

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        10 years ago

        Try replacing

         

        SUM ( Table[Column] ) with 

         

        your YTD measure DAX Formula.