Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a VR arcade with twelve stations.
The arcade is open varying hours each day. I have this is a table with:
Day Name | Open | Close | Total Hours
Monday | 16:00 | 21:00 | 5
I have a date table that includes all dates, with Day Name that has a relationship to the hours table.
I have sessions. These can be for 1-12 stations, for a given date and time, and a number of minutes (30/60/90). Sessions have:
Date | Time | Number of Stations | Duration | Total Minutes
2019-08-26 | 18:00 | 4 | 60 | 240
The date has a relationship to the date table.
What I want to report on is utilization for my given report page, based on a slicer on the date table.
Essentially it's:
Total minutes of all sessions
-------------------------------
Total possible minutes during operating hours
I'm just too new to all this to figure out how I make this work. I can use calculated columns on each to total up the individual rows, but I don't know how to bring the two together. I even put them on a gauge, but how would I show a card with a percentage for a given time window?
Hi,
Share your Data Tables in a format that can be pasted in an MS Excel file. Please also show the expected result there.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |