The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a problem where I have billable hours and available hours by employee and project. Every record has 8 hours available built into it. The issue comes into play when a single employee works on multiple projects in a single day. Since there is a value of 8 available hours in each record, when an employee shows up more than once in a single day (under multiple projects) this causes available hours to be inflated (8 * however many times the employee shows up in single day). I am looking to create a measure to take the min value for each date for each employee. This way, I can sum the billable hours against a constant 8 hours available and get a correct utilization measure. I want this to work both at the individual employee level, but also aggregate correctly when looking at the dataset in it's entirety. I can't seem to attach a workbook as a new user but here is a link to the workbook in google drive. Any help is greatly appreciated!
Hi,
you could create a date table and use something like the below to create a measure of the number of hours per day:
Appreciate the idea. Correct me if I'm wrong, but I don't think this accounts for the individual employee aspect of this. This will give me a total value of 8 available hours for the entire org each day.
Apologies, try this measure=
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
80 | |
78 | |
43 | |
37 |
User | Count |
---|---|
158 | |
111 | |
64 | |
59 | |
54 |