Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 sam...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    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.

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago
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!