Cumulative Total

Hi Anonymous 

If it's calculating backwards, you may need to check that your "Month" column is formatted as "Month Year".  Once you do that, you can use a measure like below:

Measure = TOTALYTD ( SUM ( Table[Column] ) , Table[Date] )

This is the tabular view:

Hope this helps!

Theo

Hi Anonymous ,

I have created a simple smaple, please refer to it to see if it helps you.

Add an index in Power Query.

Create a measure.

Measure = CALCULATE(SUM('Table'[count]),FILTER(ALL('Table'),'Table'[Index]<=SELECTEDVALUE('Table'[Index])))

Or you can use 'table'[date]<=selectedvalue('table'[date]) replace the index part.

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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