Visualize bookings

Question

Hi everyone!&nbsp;I'm trying to visualize the bookings of different rooms and I have sample data below. I have Start Dates with time and End Dates with time and have created the column Booked Dates that goes from start to end with an increment of 1 hour.&nbsp;Any ideas how I can visualize the booked time vs. the unbooked time? General tips would be greatly appreciated as I'm stuck. I would like to be able to show the intensity of the bookings, like for a gym, both with weekday and time of day. I've tried many approaches, for example counting the number of DistinctFridays, which&nbsp; consistently return one day less than what is booked. Index for Booking = 0 is booked two Fridays, but it returns 1.&nbsp;&nbsp;DistinctFridays = SUMX(&nbsp; &nbsp; VALUES('TEST'[Index for Booking]),&nbsp; &nbsp; VAR CurrentBookingIndex = 'TEST'[Index for Booking]&nbsp; &nbsp; VAR DistinctFridayDates = &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('TEST'[Dates Booked]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR TESTAR = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS('TEST'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('TEST'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'TEST'[Weekday Name] = "Friday" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'TEST'[Index for Booking] = CurrentBookingIndex &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'TEST'[Dates Booked] = EARLIER('TEST'[Dates Booked])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(TESTAR &gt; 0, 1, 0)&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; DistinctFridayDates)&nbsp;&nbsp;&nbsp;Index for OrderIndex for BookingLab Area RoomLab AreaRoomStart DateEnd DateDates BookedWeekday NameSingle DayDuration DaysDuration HoursDuration Days GroupingDuration Days Grouping Index00PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 09:00:00FridayFALSE71793 - 7 days310PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 10:00:00FridayFALSE71793 - 7 days320PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 11:00:00FridayFALSE71793 - 7 days330PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 12:00:00FridayFALSE71793 - 7 days340PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 13:00:00FridayFALSE71793 - 7 days350PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 14:00:00FridayFALSE71793 - 7 days360PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 15:00:00FridayFALSE71793 - 7 days370PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 16:00:00FridayFALSE71793 - 7 days380PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 17:00:00FridayFALSE71793 - 7 days390PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 18:00:00FridayFALSE71793 - 7 days3100PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 19:00:00FridayFALSE71793 - 7 days3110PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 20:00:00FridayFALSE71793 - 7 days3120PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 21:00:00FridayFALSE71793 - 7 days3130PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 22:00:00FridayFALSE71793 - 7 days3140PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-18 23:00:00FridayFALSE71793 - 7 days3150PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-19 00:00:00SaturdayFALSE71793 - 7 days3160PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-19 01:00:00SaturdayFALSE71793 - 7 days3170PV23.3,P02PV23.3P022023-08-18 09:00:002023-08-25 20:00:002023-08-19 02:00:00SaturdayFALSE71793 - 7 days3

rajendraongole1 · Accepted Answer

Hi&nbsp;snilss91&nbsp; -&nbsp; I recommend using a heatmap-style visualization and some DAX measures to properly count booked vs. unbooked time. i have created dax measure in attachment. please check attached pbix file FYR
&nbsp;

Forum Discussion

Visualize bookings

2 Replies

Related content

Calculate Actual booking

MS Booking

Best book to learn Power BI, Power Query and Dax book for expert

Call a Book mark from another book mark

Bookings vs. CalendarItems in Outlook Calendar