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 was able to get the utilization by Employee to work based on the following DAX I found in the link below. However, I am not able to understand why on some employees that worked a full month do not populated the expected hours available for the month. For example, an employee Started 6/2 but in May is reflecting 8 hours available when should be zero. On another employee who worked the full month of May only shows 168 hours available when it should be 176. What could be causing this?
http://stackoverflow.com/questions/31420864/dax-utilization-measure-formula
[hours available]:=SUMX(resources,CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]<=LASTDATE(resources[termination_date_key]))))
Hi @ShortyAO ,
Is it possible to share your model data, when I click on the model data in your connection he jumps to another page (and there is no data), remember to delete confidential data.
Best Regards
Lucien
Hello,
Unfortunetly, I don't have the option to load the file.
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |