Calculate Potential Revenue from Occupancy

Hello all. Its always the questions regarding occupancy that bring me back here. Previously with the help of Anonymous , I am able to take data from my reservations and create a "daily detail" for each day of a reservation. Essentially by seeing every night of a booking, I can then use a slicer to see the nights that a room/property has no detail and is, therefore  "available". This is helpful when looking at what I have open for any given date range.

I am having trouble finding a way to reference this back to a rate table and sum the potential revenue for the selected date(s) for each available property. In my data set, within the rate table, every property has a rate for every day of the year and these dates are grouped by multiple seasons or calendar groupings. So essentially 1/1/2018 can exist for 1,000 properties and in multiple calendar sets.  Each calendar group, however, has a unique code making this easy to map. So let's say that calendar group 14 is the one in question. Every property has a rate for every calendar day in this group. 1/1/2018 -12/13/2018 etc.... 

If I use the dates found in my reservation details as the filter or the Property found attached to those reservations, I lose my mapping back to the property in the rate table when a property is open or does not have a detailed date/reservation.

I've created a condensed mini version (picture) of my dataset. Any advice on how to sum the potential rate for a property that is not booked for a given date range? Should I be looking at his from property level and then using the date as a filter, sum the rate table rates if # of bookings found equals 0? Or possibly starting with the date(s), sum the rates for each property if no reservation detail date is found? Any help is appreciated.

Thanks,