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.
Hi All! This report shows how many hours a person is 'booked' (plan time) to a project for a month. I want the values to show as a percentage based on how many working days there are in the month. If there were 160 working hours an the person was booked for 80 the value would show on the report as 50%
Calendar Table
Tempo Plans
I have a pre-calculated planned hours measure that calculates the planned hours per day based on the start and end date of the plan
Planned Hours
https://docs.google.com/document/d/14HWaDlgUfo8nCABFlFfKyQBvsa9cfpN9a1qT8RO8HbQ/edit?usp=sharing
Many thansk in advance.
Hi @ctedesco3307 ,
Can you describe the meaning of some columns in your calendar table, like [THoliday], [Tworkday] and [WorkingDay].
And what is the meaning of 12/31/1899 in the [WorkingDay], does it mean it's not working day?
Best Regards,
Jay
Hi @v-jayw-msft - thank you for responding.
THoliday are company holidays, non working days.
TWorkday is an identifier to tag if a day is a working day or not
12/31/1899 is a placeholder for a non working day - This is the calculation for the column
@ctedesco3307 , If you have working hours, Please try a measure like
divide(sum(Table[Working Hours]), Sumx(Summarize(Table, Table[Full Name], Table[Month Year], "_1", 160), [_1]))
The denominator should have something from fact table, if full name is from dimension then use employee id from fact
Thank you - @amitchandak -- Is there a way to dynamically calculate the working days per month? Instead of harad coding the 160, I want to calculate the hours compared to the working days by month , or week, I'd like it to change based on the Calendar view I have, whether it's months or weeks....
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |