cumulative suite through time

Hi PatrickByGecko,

You can create a cumulative total using a DAX measure. Here's a option you can try out:

Cumulative Quantity = 
CALCULATE(
    SUM('YourTable'[Quantity]),
    FILTER(
        ALLSELECTED('YourTable'[Date]),
        'YourTable'[Date] <= MAX('YourTable'[Date])
    )
)

If you're using a Date table (recommended):

Cumulative Quantity = 
CALCULATE(
    SUM('YourTable'[Quantity]),
    FILTER(
        ALLSELECTED('DateTable'[Date]),
        'DateTable'[Date] <= MAX('DateTable'[Date])
    )
)

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

Hi PatrickByGecko 

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 🌀.

Hi, if you want to have cumulative over time in total try below:

Cumulative Quantity =
VAR CurrentDate =
    MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
    [Quantity],
    FILTER (
        ALL ( 'Calendar'[Date] ),
        'Calendar'[Date] <= CurrentDate
    )
)

 If you want it to be reset each year then below:

Cumulative Quantity YTD =
TOTALYTD(
    [Quantity],
    'Calendar'[Date]
) 

Hi,

If you want the accumulation to start from January, then try this measure

Measure = calculate([Total],datesytd(calendar[Date]))

Hope this helps.

Hi PatrickByGecko ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Ashish_Mathur cengizhanarslan Zanqueta Jihwan_Kim Mauro89 for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

Hi, thank you to you all for your help, and sorry for this delay of answer but I went a big sick...