Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lostcustomers
Frequent Visitor

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 not seem to work for that.

Link to file here:

https://filetea.me/n3wV19TAUx0TcuQMdw62y40ng

 

 

2017-04-20_22-01-46.png

 

Any ideas on what I need to change to make it work?

Thanks for the help in advance!

4 REPLIES 4
Eric_Zhang
Employee
Employee


@Lostcustomers wrote:

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 not seem to work for that.

Link to file here:

https://filetea.me/n3wV19TAUx0TcuQMdw62y40ng

 

 

2017-04-20_22-01-46.png

 

Any ideas on what I need to change to make it work?

Thanks for the help in advance!


@Lostcustomers

Thanks for sharing the file link, however the link is not accessible for me.

As to your requestion, regarding lost customers, if you mean the Lost Customers in this blog, You can try to create a column, say [Days], to calcualate the days elapsed in the last purchase date and create another category column based on [Days] like If [Days]>30 and [Days<60], then set the category as "60" and so on.

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!


@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”?

 @Eric_Zhang

Yes, exactly!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.