LOST CUSTOMER FOR 2 MONTH

[Anonymous]

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  

[amitchandak]

@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))

or

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

[Anonymous]

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