Forum Discussion
Solved
Need help: Cumulative sum function only returns total
Hello, Edit: Along with the solution I also identified another mistake I made. There was a mismatch between the formatting of my date table and the date column in my fact table (date/time vs dat...
Hi Renate,
Try this as a measure instead, making sure to use dDato fields in visuals, not fact table dates:
_cumulativeSum = VAR __cDate = MAX(dDato[Date]) RETURN CALCULATE( SUM(OversiktKurs[Deltagere kurs]), FILTER( ALLSELECTED(dDato), dDato[Date] <= __cDate ) )Pete
I am receiving a circular dependency error - I fear it may be due to how I created my date table.
Are you trying to create this as a calculated column rather than a measure?
You shouln't get a circular dependency when creating a measure as your dDato table would not get recalculated at thatpoint.
Pete
You are correct, it completely slipped my mind.
It worked now, thank you so much for your help.
Best regards,
Renate