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.

v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you, it worked perfectly!