Occupancy rate of the building

[Gvandijk]

I am mapping out how the different spaces in the building are used. for this I have an export with all planned appointments per time slot. For each appointment I have a line with the room number and the start and end time of the appointment. These reservations vary from a duration of 15 minutes to 10 hours. I want to provide insight into the occupancy per room per quarter of an hour and present this in a visual. I cannot yet find an option to convert this into time slots of 15 minutes.

[Gvandijk]

@v-yilong-msft , thank you for your reply. I read the topic about the 15 minutes interval but the problem is that i have two colums with time (start / end) with a different duration. I woud like to visualise this data in the graph you suggested. Here is an small example of the dataset:

[v-yilong-msft · Accepted solution]

Hi @Gvandijk ,

In response to the data you provided further, here are my answers.

Create a table of what you are showing.

Create a new calculated column to calculate elapsed time.

Column = HOUR('Table'[Duration]) * 60 + MINUTE('Table'[Duration])

Then calculate the number of experiences every 15 minutes.

Column 2 = 'Table'[Column] / 15

Finally turn it into a visualization to get the results you need.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yilong-msft]

Hi @Gvandijk ,

Based on your questions, here are my answers.

I started by creating a table based on your description.

Then create a new column named 15Min_Data. Here are the DAX codes:

15Min_Data = ROUNDDOWN('Table'[Time] * 24 * 60 / 15, 0) / (24 * 60 / 15)

Now you can create visuals based on this new column.

It is possible to determine the time interval based on this image, and you can also read this topic for more information: Solved: Creating 15 Minute intervals from Date and Time Co... - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.