cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Occupancy rate of the building

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.

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
New Member

@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:

Community Support

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.

Community Support

Hi @Gvandijk ,

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) .

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.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors