sum per time (month) using start and end date from table

[Rom_A]

Hi all,

I am very new to power bi and would appreciate some help. Have a table something like the one below

count	StartDate	EndDate
25	1/1/2021	3/31/2022
17	3/1/2021	12/31/2021
32	6/1/2021	6/1/2022
44	7/1/2021	10/31/2022
14	1/1/2022	12/31/2022
21	1/1/2021	3/31/2022
10	2/1/2022	12/31/2022

from this I would like to create a graph as shown below where a total sum from all rows that the month is in the range of the start and end date:

thanks in advance

Rom

[Rom_A]

@Greg_Deckler

Hi

First I would like to express my appreciation for your very prompt reply. It seems that the Periodic-Billing is in line with what I need.

I do apologize for taking time to accept your solution, being very new to power BI it is taking me a while to implement. To start, I wasn’t aware the measure is based on a disconnected date table whereas my date table was connected, which produced ‘weird’ results. Which brings me to the question is there a solution where the tables are connected?  

Subsequently, I found if dates were missing in any rows the measure returned an error. Which brings me to the next question is there a solution where the rows with missing dates are not analyzed by the measure?

Thank you

Rom

[Greg_Deckler · Accepted solution]

@Rom_A 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365