Forum Discussion
Solved
Current and Previous Cycle Count Based on Overlapping Cycles
This has been buggling my brain for the past few days. I have the following model, with a single fact table. The Offer Cycle and Offer Cycle Comparison dimension tables are basically just a l...
Summarized Applicant Count - Previous Period = CALCULATE( DISTINCTCOUNT(CombinedFacts[Applicant ID]), FILTER( ALL(CombinedFacts), CombinedFacts[Phase Count Flag] = 1 && CombinedFacts[days_in_cycle] = MAX(CombinedFacts[days_in_cycle]) && CombinedFacts[reporting_date] = CALCULATE( MAX(CombinedFacts[reporting_date]), FILTER( ALL(CombinedFacts), CombinedFacts[reporting_date] < MAX(CombinedFacts[reporting_date]) && CombinedFacts[days_in_cycle] = MAX(CombinedFacts[days_in_cycle]) ) ) ) )
Hi odl001, let me check if I understood correctly.
Previous cycle should be the previous reporting date which has the same days in cycle?
That is correct MattiaFratello. In my example, 23 May 2024 and 25 May 2025 are both 280th day of the cycle, both in previous and current cycle.