Forum Discussion

MattScruggs's avatar
MattScruggs
Frequent Visitor
6 years ago

Item falling between 2 dates filter by calendar date heiarchy

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 ...
Need Help
MattScruggs's avatar
MattScruggs
Frequent Visitor
5 years ago

Build DateDemo Date

1/22/2020 
1/23/2020 
1/24/20202/20/2020
1/25/20202/21/2020
1/26/20202/22/2020
1/27/20202/23/2020
1/28/20202/24/2020
1/29/20202/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])
)
)