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.
Hello. I am trying to calculate the space utilization rate for classrooms on a daily basis. Space utilization rate is defined as (Hours Used/Hours Available)x100. I've been able to figure out how to calculate the Hours per Session (which I plan to then sum by day to get Hours Used), but where I'm stuck is mapping out those Hours per Session to the specific dates that the class takes place. I've gotten as far as using a GENERATE statement using my Meeting Info table and my Date table to get the dates between the start and end dates of the class, but I can't figure out how to get only those dates that reflect the days of the week when the class takes place.
Here's my data structure:
Meeting Info table that has the following columns:
Date table that has the following columns:
The GENERATE statement that I've been trying to work with (although I'm open to getting rid of it if necessary) is:
DatesBetweenStartAndEnd =
GENERATE (
'Meeting Info',
FILTER ('Date',
'Date'[Calendar Date] >= EARLIER ( 'Meeting Info'[Start Date] )
&& 'Date'[Calendar Date] <= EARLIER ( 'Meeting Info'[End Date] )))
Would anyone be able to help with either modifying the GENERATE statement to pull only dates that match up with days of the week when a class takes place or with a new method of being able to calculate space utilization rate by day? Thanks in advance!
Solved! Go to Solution.
Hi @jbenedict2,
See my solution here.
Hope this helps.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |