Forum Discussion
Solved
Churn calculation
Hi all, There is obviously already tons of different churn-threads in here, but I wasn't able to find one for my case (may very well be me not knowing what to search for..) Simplified, but th...
You could create a calculated column like
Has further contract = var currentEndDate = 'Table'[EndDate] return NOT ISEMPTY( CALCULATETABLE( 'Table', ALLEXCEPT('Table', 'Table'[CustomerID]), 'Table'[StartDate] >= currentEndDate ) )
