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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Luca2020
Helper I
Helper I

KPI - Lead Conversion Rate

Hi, 

I've the folowing table with the name of all of our Customers and Potential Customers (Leads),     

          

TypeNameInsert as Lead (Date)Conversion Lead to Costumer (Date)
Leadxx01/01/2020 
Leadyy04/06/2020 
Customerzz25/08/202005/10/2020
Leadww12/09/2020 

 

In this table there is also the date the name was entered in our database as lead and the date this lead became an actual customer.

 

I want a measure that show for a specific date (used as filter in the report so it could be a specific month or a from ... to ... date)  the conversion rate (N. of inserted leads in this period / N. of converted leads, non necessarelly the same leads)

ES. in the first 10 month of 2020 4 leads were entered and 1 become a customer (25%). 

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Luca2020 , Please refer to my HR blog, similar kind of problem is addressed

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Luca2020 , Please refer to my HR blog, similar kind of problem is addressed

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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