Running Total of last date of each month - upto the current date

[Anonymous]

Hi, 

I'm struggling to create a Running Total Calculation that sums up the value of the last date (upto the current date) of each preceeding month. 

Here are my workings so far

The RT for the row Start of Month 01/03/2020 and Start Week 07/03/2020 - should be 1167

The RT for the row Start of Month 01/04/2020 and Start Week 07/03/2020 - (should be 1167 + last date of March, not beyond current date = 1167) = 2333

The RT for the row Start of Month 01/04/2020 and Start Week 27/04/2020 - (should be 1417+ last date of March, not beyond current date = 1167) = 2584

The RT for the row Start of Month 01/05/2020 and Start Week 07/03/2020 - (should be 0+ last date of April, not beyond current date = 1167 + last date of March, not beyond current date = 1167) = 2333

The RT for the row Start of Month 01/05/2020 and Start Week 27/04/2020 - (should be 2917+ last date of April, not beyond current date = 1417 + last date of March, not beyond current date = 1167) = 5501

The RT for the row Start of Month 01/05/2020 and Start Week 16/05/2020 - (should be 4345+ last date of April, not beyond current date = 1417 + last date of March, not beyond current date = 1167) = 6929

I've looked at these articles:

https://www.sqlbi.com/articles/using-keepfilters-in-dax/

https://www.sqlbi.com/articles/filter-arguments-in-calculate/

https://www.sqlbi.com/daxpuzzle/last-date/

https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/

But am still struggling. Pls help!

Sachin

[dedelman_clng]

Hi @Anonymous 

Based on your screen shot you created a calculated column instead of a measure.  Use the same code as a measure (put the data including the measure into a table visual to see the results) and see if that fixes it.

Hope this helps

David