Learning summit August 2018 - Attrition Analytics Question

DAX DAX Calculations
1

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

2

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
3

Thanks, Sam, great help.