Cumulative time slicer calc

Hey Adriaan,

sorry for the delay, I had to take care of some urgent family affairs, but nevertheless, here is my solution

As you can see, the subtotal does not show what one would expect. This can be treated by a simple IF(HASONEVALUE('DimDate'[DateValue]), thecalculation, BLANK()) or by a more complex adoption of the calcualtion itself.

The basic idea behind this solution is depicted in your Excel file (sheet: Investment), your Excel file and the pbix are

here

The solution makes use of nested TableIterator SUMX(table, PRODUCTX(table, expression)*sum('Investment'[Investment])...) and the always mind-boggling EARLIER(...)

I will explain this solution in much more detail, in the next days on my blog and will post the link to my blog.

I have to admit that was not the easiest one :-)

Hope this helps

Tom