Best approach to building a line graph using date ranges

[Rads2929]

Hello, I need to build a line graph. The underlying data has an opened and closed date in the table. Graph y axis is counts and the x axis is number of recordIDs. A date slicer will be used to narrow or expand the date range.

RecordID     Opened        Closed

1                  2021-01-07   2021-05-09

Three lines on the graph.

Line 1 - Represents Opens

Line 2 - Represents Closes

Line 3 - Represents Remained open

So the record above would display the following

Line 1 - shows 1 for Jan2021

Line 2 - shows 1 for May2021

Line 3 - shows 1 for Feb2021, Mar2021, Apr2021

Im thinking that I may need to create a calculated table based on the the table presented above or perhaps I can use measures to accomplish this easily?

[Greg_Deckler · Accepted solution]

@Rads2929 
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