Show Occupancy for selected dates !!

[Aditya_K1999]

Hi Guys,

I have a table with the check-in date & check-out date for a particular booking. And also a status column.

I want that when I put a specific start date & end date, the system should show me all the people who have booked a service between those dates. So it should not only consider the start date & end date, but also the dates in between. I had used the below formula but it did not work much..I have put this formula in a VC

Select(Services Availed[Pet ID],OR([Check In Date - Dash]>=[_THISROW].[Start Date],[Check-Out Date - Dash]<=[_THISROW].[Start Date]))

[lynchk21]

Select(Services Availed[Pet ID], OR(AND([Check In Date - Dash]>=[_thisRow].[Start Date],[Check In Date - Dash]<=[_thisRow].[End Date]),AND(([Check-Out Date - Dash]>=[_thisRow].[Start Date],[Check-Out Date - Dash]<=[_thisRow].[End Date])))

I think you will need something like above

You want any booking that either:

• Has a [Check In Date - Dash] that is greater than or equal to [Start Date] AND less than or equal to the [End Date]

OR

• Has a [Check-Out Date - Dash] that is greater than or equal to [Start Date] AND less than or equal to the [End Date]

[Joseph_Seddik]

You should have:

1. Dates table
2. Referencing each date you should have:
   1. An Arrivals table.
   2. Ongoing Stays table.
   3. A Departure table.

After each registry, a bot should add new rows in the corresponding a., b. and c. tables. That's how you maintain your occupation, not through a virtual column. 

Your occupancy for a date will be the sum of the related Arrivals and the related Stays. 

Another bots would manage removing the corresponding lines in case of early Departure and adding new ones in case of post-reservation extended stays, adjusting the new Departure dates in both cases.