Help Using One Slicer for Two Date Columns

[Anonymous]

I have a table with a start date column and an end date column. I was wondering if there is a way to have a slicer check to see if either is in the date range but only count that row once. For example, I was trying to find out how many pieces of equipment were on rent for a certain month. I have the start date and end date for when it was on rental and sometimes these are in different months (sometimes across 2 months, never 3), so the start date might be 1/2015 and the end might be 2/2015. I want my slicer to count this row for both January and February. Does that make sense? 

I made a new table with just dates in it, but I am not sure how to link it to two columns in the same table. Or if this is even the right way to attempt it. 

Example:

Equipment Type       Rent Start       Rent Stop

Widget                3/2015            4/2015
Widget                4/2015            4/2015
Widget                3/2015            3/2015

 I would want that to show 2 Widgets for March and two Widgets for April

[Greg_Deckler · Accepted solution]

Take 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

[Anonymous]

That worked like a charm, thanks!