In-Depth Customer Churn, New Customers & Lost Customers Examples In Power BI using DAX

DAX DAX Calculations
1

Hi DNA Team,

I noticed that SAM formula is slightly incorrect for Returning Customer.

image
image960×292 52 KB

Whereas it should be:
Returning Customers =
VAR CustomersList = VALUES( Sales[Customer ID] )
VAR ChurnDate = 90

RETURN
COUNTROWS(
FILTER(
CustomersList,
CALCULATE( COUNTROWS( Sales ),
FILTER( ALLSELECTED( Dates ),
Dates[Date] > (MIN( Dates[Date] ) - ChurnDate ) &&
Dates[Date] < MIN( Dates[Date] ) ) )
> 0 ) )
//evaluating how many customers have returned if no sale in last 90 days

The above formula was given in the Advanced analytics course.

1 Like
2

Hi @Matty

I have checked the video and the accompanying material. In both places, Sam has used “> 0”. In Video, Initially it was “= 0” but was changed to > 0.

Thanks
Ankit J

1 Like
3

Hi @Matty, did the response provided by @ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!