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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
admin11
Memorable Member
Memorable Member

How to locate high risk customer ?

Hi All

Can some one share with me , what are the way to detech high risk customer ? 

Base on my personal thinking , i think one way to check is using AR report , and check which are those customer have long out stand > 150 days , and last 5 month not purchase any goods.

 

If you have better idea , hope you can share with me. Or you know any link that provide info on this , will be apprecaited.

 

Paul 

1 ACCEPTED SOLUTION
PC2790
Community Champion
Community Champion

Hello @admin11 ,

 

You can refer this article to get the list of customers whoch have not made any purchase in a specific period:

https://radacad.com/lost-customers-dax-calculation-for-power-bi

 

View solution in original post

1 REPLY 1
PC2790
Community Champion
Community Champion

Hello @admin11 ,

 

You can refer this article to get the list of customers whoch have not made any purchase in a specific period:

https://radacad.com/lost-customers-dax-calculation-for-power-bi

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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