Running totals Column

[Anonymous]

Hello everyone,

I am trying to create a 'year to Date' columns calculating the cummulative value from the colum [Value]. However, as you can see in the picture below, the measure is repeting the same value and not adding the value over time. Note that my date range is in a weekly basis (column week date)... maybe it could be a issue to use this measure. Also I have tryied to use the TotalYTD function and the result is the same as shown in the 'Year To Date' column. Any Idea on how to fix this DAX? 

Thansk!

[Mahesh0016]

cumulative Sales = CALCULATE (

    SUM ( 'Table'[Sales] ),

    FILTER ( ALL('Table'), 'Table'[Date] <= MAX ( 'Table'[Date] ) )

)

Hello @Anonymous ,
You should try this formula...... if it is really useful for you kindly accept as solutions.

thank you!

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous ,

I made a sample and here is my solution,

You can create a calculated column as below to return your expected output.

Column =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER ( 'Table', 'Table'[week date] <= EARLIER ( 'Table'[week date] ) )
)

Final output:

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you, it worked perfectly!