Forum Discussion
Running totals Column
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!
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- 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!
