Forum Discussion
Lost Customers
Hello All,
I am very new to power bi, I was practising a exercise in which i need to find lost customers .
After Various searches i did figured out the caluculaiton part, But i didn't understand the logic behind.
LostCustomers = Var Customers=ALLSELECTED(Orders[CustomerCompany])
Var TimeFrame=90
Return COUNTROWS(FILTER(Customers,CALCULATE(COUNTROWS(Orders),FILTER(ALLSELECTED('Date'[Date]),'Date'[Date]>MIN('Date'[Date])-TimeFrame&&'Date'[Date]<MIN>MIN('Date'[Date])-TimeFrame&&'Date'[Date]<MIN></MIN></MIN>
I am very new to power bi, I was practising a exercise in which i need to find lost customers .
After Various searches i did figured out the caluculaiton part, But i didn't understand the logic behind.
LostCustomers = Var Customers=ALLSELECTED(Orders[CustomerCompany])
Var TimeFrame=90
Return COUNTROWS(FILTER(Customers,CALCULATE(COUNTROWS(Orders),FILTER(ALLSELECTED('Date'[Date]),'Date'[Date]>MIN('Date'[Date])-TimeFrame&&'Date'[Date]<MIN>MIN('Date'[Date])-TimeFrame&&'Date'[Date]<MIN></MIN></MIN>
