Cumulative sum by year not working for measure

[Anonymous]

I Read multiple posts and tried multiple variants to write this formula but it isn't working as expected.

Simply put, I want "Measure 3" to be running total of Measure Tax Due.

This is the code I'm using for Measure 3:

Measure 3 =

var maxdate = max(years[year])

return

calculate([Tax Due], years[year]<=maxdate, All(years))

--> The calculation seems to be right on the last year - all the other values seem messed up...

I also tried using fields formatted as date:

but got exactly the same result:

@Anonymous 

Any help would be highly appreciated!

[v-yalanwu-msft]

Hi, @Anonymous ;

This is supposed to be matrix, right? I'm a little confused about your data,like below:

If use table ,it will show right.

So can you share more information about your data or share .PBIX to remove sensitive information？

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , you should prefer separate year/date table

Measure 3 =
calculate([Tax Due], filter(allselected(year), years[year]<=max(years[year])))

or

Measure 3 =
calculate([Tax Due], filter(allselected(year), years[Date]<=max(years[Date])))