Forum Discussion
Room Utilization by Day and Hour
Hi, tsupani
According to your expected result, I think what can be achieved in Power BI is the data part, this is the result I can achieve:
What’s more, I don’t think the detailed data(room number and time period) can also be displayed in Power BI Matrix, I suggest you to accept this reply as a solution and open a new case to ask this question so that more exports can research whether this can be achieved in Power BI.
This is my test pbix file according to your expected result(My steps is similar to the steps I mentioned before):
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Usertsupani , first of all you need an hourly bucket . See if time table or a merge with time table can help
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
then this measure should work
divide(distinctcount(Table[Room]), calculate(distinctcount(Table[Room]), allselected(Table)))