KPI - Lead Conversion Rate

Luca2020 — Fri, 18 Dec 2020 13:30:29 GMT

Hi,

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

Type	Name	Insert as Lead (Date)	Conversion Lead to Costumer (Date)
Lead	xx	01/01/2020
Lead	yy	04/06/2020
Customer	zz	25/08/2020	05/10/2020
Lead	ww	12/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!

Re: KPI - Lead Conversion Rate

amitchandak — Fri, 18 Dec 2020 15:14:54 GMT

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-trend/ba-p/882970

topic KPI - Lead Conversion Rate in DAX Commands and Tips

KPI - Lead Conversion Rate

Re: KPI - Lead Conversion Rate