Calculate Number of Active Clients by Month

[comerlatto_tcr]

Hello!

nedd help with a measure, tried several approaches without success.
I'm trying to calculate number of active deals by month. I have a table called pipedrive that has a start_date and a end_date column with an active relationship to dim_date table on the end_date:

What I want for result is, when a deal start_date is for example 15/12/2023 and the end_date is 02/02/2024, it needs to show in december, january and febuary.
Hope someone can give me a help with that!

[amitchandak · Accepted solution]

@comerlatto_tcr , seems very similar to HR analytics Active/current employees, the file is attached filter signature

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU