Latest Enterprise DNA Initiatives

Learning summit August 2018 - Attrition Analytics Question

Hi,
In the New Customers measure (Churn Analytics) you work with 30 days and in Lost Customers with 60 days. Would it be complicated to change this to 1 month or 2 months?

Paul

No shouldn’t be at all.

Want you could do is use the DATE function and manipulate the parameters inside this.

Eg.

DATE( YEAR( Date column ), MONTH( Date Column ) - 1, DAY( Date Column ) )

Something like this

Give this a go and let me know how it goes.

You can also use DATESBTWEEN

Something like this (it’s quarters I know but you can change this over to months )

Won Customers LTM = 
VAR CustomerLTM = CALCULATETABLE(VALUES(Invoices[Customer]);
                         DATESBETWEEN ('Calendar'[Date];
                         NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Calendar'[Date] ) ) );
                         LASTDATE ( 'Calendar'[Date] )))
VAR PriorCustomers = CALCULATETABLE(VALUES(Invoices[Customer]);
                       DATESBETWEEN('Calendar'[Date];
                        DATEADD(STARTOFQUARTER('Calendar'[Date]);-4;QUARTER);
                        DATEADD(ENDOFQUARTER('Calendar'[Date]);-1;QUARTER)))              
RETURN
COUNTROWS(
    EXCEPT(CustomerLTM;PriorCustomers))
1 Like

Thanks, Sam, great help.