Aggregate a cummulative sum builded with TOTALYTD

[froebm]

Hello,

I have used the formula TOTALYTD to create a cumulative total that displays the stock data per month. So far everything is fine.

Bestand kum. (VK-Wert) = 
TOTALYTD(sum(tblLieferantenKER[lkerBestand (VK-Wert)]),tblDateTable[Date], tblDateTable[Monthnumber] <= max(tblLieferantenKER[lkermm]))

But now I would like to aggregate the result values of "Bestand kum. (VK-Wert)" again. In other words: January = January or 872,073; February = January + February or 872,073 + 936,985 etc.

I'm kind of stumped and can't get any further

Thanks in advance for your help.

Best regards,

Max

[froebm · Accepted solution]

After a short break I found the solution. For those beeing interessted in it:

    CALCULATE(
        SUMX(
            VALUES(tblDateTable[Monthnumber]),
            [Bestand kum. (VK-Wert)]
        ),
        FILTER(
            ALL(tblDateTable),
            tblDateTable[Monthnumber] <= MAX(tblDateTable[Monthnumber])
        )
    )