Forum Discussion
Solved
Cumulative sum two dates condition
Hi all, I am trying to add cumulative sum based on two different dates. I have example data like below: Value Ready Date Implement Date 1 Dec 2023 Dec 2023 3 Dec 2023 Dec 2023 ...
It works now I figured it out by linking the two dates column to a new date table. Then I use USERELATIONSHIP as filter and pass into the filter. Thank you for your help regardless.
Jihwan_Kim
Super User
Super UserHi,
I am not sure if I understood your question correctly, or I do not know how your semantic model looks like, but please check the below picture and the attached pbix file.
expected result measure 1: =
CALCULATE ( SUM ( data[Value] ), REMOVEFILTERS ( 'Calendar' ) )
expected result measure 2: =
CALCULATE ( SUM ( data[Value] ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
Hi, thanks for the response.
I think not quite, I may have provided the ready date as the same; however, as I need each date column to act as the condition. For example data below:
| alue | Ready Date | Implement Date |
| 1 | Dec 2023 | Dec 2023 |
| 3 | Dec 2023 | Dec 2023 |
| 5 | Dec 2024 | Dec 2024 |
| 7 | Dec 2024 | Dec 2025 |
Expected result should be
Is there a way to cumulative each sum based on the date column it's corresponded to? Thanks
| Year | Cumulative Ready | Cumulative Implement |
| 2023 | 4 | 4 |
| 2024 | 16 | 9 |
| 2025 | 16 | 16 |