trying to find the number of occupied sites from a range of dates

[abeirne]

Hi all, I have a very particular task. I am trying to find the number of occupied sites from a range of dates (Arrival to Departure). I have a calendar table connected to Arrival Date, and a Category table for my units/site types. I was thinking expanding the dates between arrival date and departure date, but I have a lot of data and don't want to slow things down.
What I am trying to see is that from December 9, 2022 through December 12, 2022, there were 2 Available Sites for each day, and this reservation occupied 1 site for the range of dates. Is there any possible way to do this? Thank you so much. 

[amitchandak · Accepted solution]

@abeirne , Such case we try split the data days wise and check

https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

or

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Or refer to one file attached

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.