This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hello again everyone!
I found myself in a persiting doubt and I want to know if someone has faced it before.
My questions is: How can I calculate the converted leads that occured in the same month?
I want to calculate a 'Relative" conversion rate, in a especific cenario and I will try to picture it out:
I have some leads ocurring in month 4, by their ID's. Some of them, converted in the same month. The rest of them, in the next month.
I need to know the convertion rate of all leads ocurring in the same month.
Is there any way to mark them if they converted or not in the same month?
I know its a bit fuzzy but I really hope that could be understood.
Thanks!
Solved! Go to Solution.
Hi @RodrigoAC
Are those two tables - LEADS & SALES your fact tables? And the below one with Conversion Rate what you want? Do you have a Date slicer to filter down to the range of April 25 - May 2?
Hi @RodrigoAC
Are those two tables - LEADS & SALES your fact tables? And the below one with Conversion Rate what you want? Do you have a Date slicer to filter down to the range of April 25 - May 2?
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 29 | |
| 29 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 39 | |
| 33 | |
| 24 | |
| 23 |