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:
date of delivery
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?
Go to Solution.
@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,
View solution in original post
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?
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.
@CNENFRNL , thank you! Solved!
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!