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.
With the measure below i calculate the workable hours:
Solved! Go to Solution.
It didn't solve the problem.
But with some try and error i found the solution:
Hi @Oomsen
Could you please specify the meaning of your formula? I can barely understand it. It’s preferred to share us your detailed data (upload your pbix to Onedrive and share links here) but kindly masking your confidential info.
We’d like to provide further support once we got it.
Best regards,
Dina Ye
Hi @v-diye-msft
The measure is ment for counting available working hours and compare them with the actuals worked hours of employees.
I will translate it to english:
Hi @Oomsen ,
FIf my understanding is correct, you'd like to compare the standard workhours with actual workhours. your standard workday is from Monday to Friday, with 7.6 hours per day.
I created a calenday table list from 7/1 -today, then add the calculated column to specify the weekday, finally add the measure to generate the total standard workhours: results shown as below, you can find the pbix here:
Best regards,
Dina Ye
It didn't solve the problem.
But with some try and error i found the solution:
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |