Forum Discussion
Counting Values Between Two Dates
Hi All,
Here is a summary of what my table contains:
One column is a project number (CFAS_PROJECT), where there are thousands of unique values. Each unique value is tied to what we will call several 'milestones'.
For example
MA00555 appears 5 times, for milestone 1, 2, 3, 4, 5
Each milestone has a date (ACTUAL_DATE) that it occurred at.
For example, horizontally: MA00555 - 1 - 1/1/2023
I have created another date column that is as follows:
Previous Milestone Date =
CALCULATE (
MAX ( '0.0 MAIN DATABASE'[ACTUAL_DATE] ),
FILTER (
ALLEXCEPT (
'0.0 MAIN DATABASE',
'0.0 MAIN DATABASE'[CFAS_PROJECT_NUMBER]
),
'0.0 MAIN DATABASE'[ACTUAL_DATE]
< EARLIER ('0.0 MAIN DATABASE'[ACTUAL_DATE])
)
)
I am trying to count every month that is between the date that the milestone occurred at, and when the previous one did. For example, if milestone 2 occurred in January, and 3 occurred in April, I would like the number '1' to appear in january, february, march, and april. Any support or tips that you might have would be greatly appreciated! Thank you!
No RepliesBe the first to reply