Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Icon for Helper V rankHelper V
8 months ago
Solved

cumulative suite through time

Hi everybody, Underneath I have a suite of quantities each month, I mean => 4,3,2,1 etc.. . I would like to get the cumulative suite of theses quantities, I mean => 4, 7, 9, 10 etc.. How can I do ...
Need Help
Zanqueta's avatar
Zanqueta
Icon for Super User rankSuper User
8 months ago

Hi PatrickByGecko 

To achieve a cumulative sequence like 4 ā†’ 7 ā†’ 9 ā†’ 10 from monthly quantities, you do not need TOTALYTD unless you are working with a date hierarchy and want Year-To-Date totals. For a simple cumulative sum across months
 
If your Date table has a proper Date column:
 
CumulativeQty_YTD =
TOTALYTD(
    SUM('YourTable'[Quantity]),
    'Date'[Date]
)

 

If this response was helpful in any way, Iā€™d gladly accept a šŸ‘much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop šŸŒ€.