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!
