Forum Discussion

Lostcustomers's avatar
Lostcustomers
Frequent Visitor
9 years ago

Lost costumers sqlbi formula issue

Hi, I am trying to reuse sqlbi lost customers formula to create a visualizatin of which customers I have lost. I dont wont to count them, I want to know who they are. Unfortunately, the formula does...
Need Help
Lostcustomers's avatar
Lostcustomers
Frequent Visitor
9 years ago

Hi Eric_Zhang

 

Unfortunately not yet.

 

Here is a new link with the file:

http://gofile.me/2kEOD/Aqw0IWDiS

 

I want the customer to be able to select the lost period and year in a slicer.

Your solution works for 2017 but not sure how to do it for previous years...

 

Any ideas? and many thanks for your help!

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Lostcustomers wrote:

Hi Eric_Zhang

 

Unfortunately not yet.

 

Here is a new link with the file:

http://gofile.me/2kEOD/Aqw0IWDiS

 

I want the customer to be able to select the lost period and year in a slicer.

Your solution works for 2017 but not sure how to do it for previous years...

 

Any ideas? and many thanks for your help!

Thanks for sharing the pbix file. One more question, when "2008" and "540" are selected in the slicers, would you like that the customers who didn't have any purchase order between “2008-12-31”-540 days and ““2008-12-31”?