Forum Discussion

Ram_DCT's avatar
Ram_DCT
Helper II
5 years ago

Split Cumulative Sum

Hi Team,   I am looking to split my cumulitive sum and get day wise hours spent on a work item id. Please ntoe that, for each wokr item - date column would be be continuos and we need to split cum...
Need Help
Tips and Tricks
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Ram_DCT 

you can try this,

Calculated1 = CALCULATE(MAX('Table'[Completed Work]),FILTER(ALLEXCEPT('Table','Table'[Work Item Id]),'Table'[Date]<EARLIER('Table'[Date],1)))
Final Result = 'Table'[Completed Work]-'Table'[Calculated1]

result

 

 

Best Regards,

Community Support Team _Tang

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