Item falling between 2 dates filter by calendar date heiarchy

[MattScruggs]

I have a data set with a few thousand line items. In this, there are 2 columns, a start date, and an end date. I am looking for a way to determine if an item was standing during a certain date. This is easy to do with a simple if statement, but the problem Im having is that I want to be able to filter it at the visual level by any date, selected by the user.  I have [ActualBuildDate] and [ActualDismantleDate] Where [ActualBuildDate] will aways have a date, and [ActualDismantleDate] will alway be after [ActualBuildDate] or blank (Still standing).  If I select January 2020, I want to see every item that was standing during January 2020. I have a Calender table set up using this code  Date Filter = DATESBETWEEN( 'Date'[Date], MIN('1_Overview'[ActualBuildDate]), IF(MAX('1_Overview'[ActualDismantleDate]) > MAX('1_Overview'[ActualBuildDate]), MAX('1_Overview'[ActualDismantleDate]), MAX('1_Overview'[ActualBuildDate]) )) I have set a filter with a date heiarchy using this. but filtering by the dates on it do not return the proper items. 

[MattScruggs]

Build DateDemo Date

1/22/2020
1/23/2020
1/24/2020	2/20/2020
1/25/2020	2/21/2020
1/26/2020	2/22/2020
1/27/2020	2/23/2020
1/28/2020	2/24/2020
1/29/2020	2/25/2020

My dates look like this. 

This is the formula for my Calender table

Calendar = CALENDAR(MIN('1_Overview'[ActualBuildDate]),

IF(

MAX('1_Overview'[ActualBuildDate]) > MAX('1_Overview'[ActualDismantleDate]),

MAX('1_Overview'[ActualBuildDate]),

MAX('1_Overview'[ActualDismantleDate])

)

)

[Anonymous]

@MattScruggs 

Maybe provide a short sample data.

Regards
Paul

[amitchandak]

@MattScruggs , not very clear. If you want to same date range to be filtered on both dates. You can join them to the same date table. Active/inactive joins will be created. And you can use join on choice using use relation.

example :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://www.youtube.com/watch?v=e6Y-l_JtCq4

If case you need different date ranges then you can have a date range on these two dates or you can create two date tables. One joins with each date.