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
  • Jihwan_Kim's avatar
    Jihwan_Kim
    8 months ago

    Hi,

    One of ways to achieve this is to use visual calculation.

    I tried to create a sample pbix file like below, and please check the below image and the attached pbix file.

     

     

  • v-venuppu's avatar
    v-venuppu
    8 months ago

    Hi PatrickByGecko ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.

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 šŸŒ€.