topic Re: cumulative sum based on a variable data range in DAX Commands and Tips

cumulative sum based on a variable data range

STF29 — Sat, 13 Mar 2021 10:01:00 GMT

Hi Everyone,

I need a dax function that provides a cumulative sum based on a variable range of dates.

I have a table with details of the Contract:

And a table of Deliveries:

I need to monitor the cumulative sum of quantity delivered, for each month, referring to the duration of the contract.

Example of expected result:

Can anyone please help?

Thanks

CNENFRNL — Sat, 13 Mar 2021 16:54:22 GMT

STF29 , your question is interesting and here's a tricky solution.

Convert your contract table to the following form for the purpose of filtering in DAX,

STF29 — Sat, 13 Mar 2021 20:21:57 GMT

Hi CNENFRNL, thank you for your quick support!

Could you please suggest a way to convert the contract table to the format that you proposed?

Many thanks

CNENFRNL — Sun, 14 Mar 2021 04:05:33 GMT

Hi, STF29 , in the attachment of my preceding reply, you might want to go through all applied steps of convesion in detail in Power Query.

STF29 — Sun, 14 Mar 2021 11:55:15 GMT

CNENFRNL , thank you! Solved!