Forum Discussion
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 areThe 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
Super UserHey 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
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
Will definitely be keen to see your workings and explanation when you have it posted on your blog ...need to apply this somehow ;)
- TomMartens
Finally, here is a much more elaborated explanation of a solution for the problem and it also contains an additional twist, using an interest rate coming from a separate table:
https://docs.com/minceddata/3687/dax-using-iterations-to-calculate-a-future-value?c=B13yYP