Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!
Solved! Go to Solution.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 8 | |
| 7 | |
| 6 |