Show all Dates Between for Arrival and Release Dates for Multiple ID's

[DerekC]

I have a need to show a trend of number of assets at a certain location.  I have arrival and release dates, but I want to show total number of all at the location on a daily basis.  Below is a simplified version of the data and graph I am looking for.  

ID	Arrive	Release
1	1/10/2023	2/2/2023
2	1/15/2023	2/5/2023
3	1/31/2023	2/10/2023
4	2/3/2023	2/10/2023

[johnt75 · Accepted solution]

Try

Num at location =
VAR CurrentDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[ID] ),
        'Table'[Arrival] <= CurrentDate
            && (
                'Table'[Release] > CurrentDate
                    || ISBLANK ( 'Table'[Release] )
            )
    )

[DerekC]

Thank you!  I just made sure that my relationship between the date table and my data table was inactive and it worked.