Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
For an analysis I woud like to calculate the Utilization/Occupancy rates of the docking stations.
Information used:
Amount of time occupied: BezettingstijdDock
Hours on a day: 0 to 23
Docking station: 1 to 10
Workings hours: 17/24
Im trying the following formula: Utilization = (SUM(Table[BezettingstijdDock])/(17/24)
The total percentage of occupancy will fit, but since I added a time factor in the table my measure does not fit anymore.
Any help would be appreciated :-)!
Solved! Go to Solution.
@Anonymous - I did this:
Measure 15 = SUMX('Table (15)',[OccupancyTimeDec]) / (1/24)
PBIX is attached below sig. Page 15. Not sure it is what you are looking for or not. @ me if you reply. Thanks.
@Anonymous , Difficult to tell. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
Only one thing if you were expecting percent, you should check the percent option in measure tool
During the day (consisting of 17 workings hours) a Docking station can be occupied by one truck.
However, I want to calculate the occupancy rate (%) of the dock for each working hour. I am using the following data: Dock data, OccupancyTime in minutes and the hour in which a truck is at the dock (can be more than 1 in one hour).
Dock | OccupancyTimeDec | Hour | OccupancyTimeMin |
8 | 0,00767338 | 7 | 00:11:02 |
2 | 0,008172801 | 7 | 00:11:46 |
9 | 0,007590046 | 8 | 00:10:55 |
4 | 0,007100116 | 8 | 00:10:13 |
1 | 0,006944444 | 8 | 00:10:00 |
5 | 0,006944444 | 8 | 00:10:00 |
8 | 0,006944444 | 8 | 00:10:00 |
1 | 0,006944444 | 8 | 00:10:00 |
9 | 0,006944444 | 8 | 00:10:00 |
@Anonymous - I did this:
Measure 15 = SUMX('Table (15)',[OccupancyTimeDec]) / (1/24)
PBIX is attached below sig. Page 15. Not sure it is what you are looking for or not. @ me if you reply. Thanks.
@Anonymous Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |