Thank You for posting your query onto the Forum.
Below are the given formulas about how “Exit Month” and “Exit Period” in the Time Based Cohort Analysis.
Exit Month =
VAR ExitDate = [Exit Date]
CALCULATE( SELECTEDVALUE( Dates[Month & Year] ),
FILTER( ALL( Dates ), Dates[Date] = ExitDate ) )
Exit Period =
CALCULATE( SELECTEDVALUE( 'Cohort Periods'[Period] ),
FILTER( 'Cohort Periods',
[Retention Days] > 'Cohort Periods'[Min Days] &&
[Retention Days] <= 'Cohort Periods'[Max Days] ) )
Also providing a working of the files as well as some of the links from the education portal about the videos on “Cohort Analysis”.
Hoping you find this useful and meets your requirements.
Thanks and Warm Regards,
Cohort Analysis Deep Dive - Harsh.pbix (1.1 MB)