topic LOST CUSTOMER FOR 2 MONTH in DAX Commands and Tips

LOST CUSTOMER FOR 2 MONTH

Anonymous — Mon, 26 Sep 2022 08:05:08 GMT

HI ALL

Ihave one issue as shown below

I need to find the lost customer for 2 month ago ( customers didn't buy from us during 2 month ago )

can any one help me on that

Abbreviations:

invd= invoice date

name = customer name

this is dax code :

LOST Customers11 =

var CustomersPurchased =CALCULATE(VALUES('Apttdsls4069s401PitemPCust'[Name]),

FILTER(ALL(Apttdsls4069s401PitemPCust[t_invd]),

'Apttdsls4069s401PitemPCust'[t_invd]> MIN('Apttdsls4069s401PitemPCust'[t_invd])- 365 &&

'Apttdsls4069s401PitemPCust'[t_invd]<MIN('Apttdsls4069s401PitemPCust'[t_invd])- 60 ))

var PriorCustomers = CALCULATETABLE(VALUES(Apttdsls4069s401PitemPCust[Name]),

FILTER(ALL('Apttdsls4069s401PitemPCust'[t_invd]),

'Apttdsls4069s401PitemPCust'[t_invd]>MIN('Apttdsls4069s401PitemPCust'[t_invd])-60 &&

'Apttdsls4069s401PitemPCust'[t_invd]<MIN('Apttdsls4069s401PitemPCust'[t_invd])))

return

COUNTROWS(EXCEPT( CustomersPurchased ,PriorCustomers))*-1

thanks

Re: LOST CUSTOMER FOR 2 MONTH

amitchandak — Mon, 26 Sep 2022 08:36:10 GMT

Anonymous , Customer buying from use for last 2 months

2 Months =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = date(Year(_max), month(_max) -2, Day(_max))+1
BLANK())
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

2 Months =
var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
var _min = eomonth(_max,-2)+1 ,
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

Then customer did not buy

Countx(Values(Customer[Customer]), if(isblank([2 Months]) , [Customer], Blank()) )

For more information refer my blog na video

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

Re: LOST CUSTOMER FOR 2 MONTH

Anonymous — Mon, 26 Sep 2022 09:04:49 GMT

i did what you told me but this result came to me