Forum Discussion
Counting leads by created on date
Hello, I want to build a Power BI where we can track our generated leads. Im getting my data from Dynamics 365 CRM and have an individual line for each generated lead. I have the created ...
Hello lbendlin,
Thank you for your answer!
Unfortunatly i cannot provide a direct PBIX file, as all the data is sensitive. But i have made a table, that shows the type of data i am working with, with made up data 🙂
| Lead | Created on | Status |
| Name 1 | 1/1/2023 | Open |
| Name 2 | 7/6/2023 | Qualified |
| Name 3 | 3/8/2023 | Disqualified |
| Name 4 | 10/10/2023 | Open |
The purpose of the visualisation would be to show all open leads on the specific month (no matter what date they are created - hence the accumulated). I think my issue is, that i keep making data that are connected to the "Created on" date, and therefore it will not show the total amount of open leads on the month......
Is the provided example enough?
- Emilie
