New Customer Analysis with Power BI - Without Churn Parameter


#1

Hi Sam,

In your example there is an input parameter for the number of churn days. How might one simplify the logic to consider any returning customer we’ve done business with an existing customer?

Thank You,
Nick


#2

This should do what your looking for I believe

New Customers All Time = 
VAR CustomerTM = VALUES( Sales[Customer ID] )
VAR PriorCustomers = CALCULATETABLE( VALUES( Sales[Customer ID] ), 
                        FILTER( ALL( Dates ),
                            Dates[Date] < MIN( Dates[Date] ) ) )

RETURN
COUNTROWS(
    EXCEPT( CustomerTM, PriorCustomers ) )