Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the structure of my data is like this:
ContractID | CustomerID | StartDate | EndDate |
1 | 1 | 01.01.2022 | 31.12.22 |
2 | 2 | 01.01.2022 | 31.12.22 |
3 | 3 | 01.01.2022 | 31.12.22 |
4 | 3 | 01.01.2023 | 31.12.23 |
ContractID 1 and 2 should be considered as churn on 31.12.22.
ContractID 3 should not be considered as churn on the 31.12.22, as the same customer has a new contract starting the day after.
Any advice on how to calculate this or pointers to existing threads already covering it?
Thanks!
Solved! Go to Solution.
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 ) )
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 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |