Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to calculate YTD Utilization by month for my team. I have two different calculations that I am trying to do. The first is per team member. The second is for the entire team.
Each month the total available utilization hours are 161.3333. There is a table that houses all of the billable hours for each team member and I am already calculatin total billable hours with a measure in Power BI. Here is an example of what it looks like in Excel as well as the calculation for May...
This is what I have currently in PowerBI for a team member report. I would like to add the YTD Utilization to this chart and possible a guage that shows the current YTD.
Any help is greatly appreciated!
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE([Billable hours],DATESYTD(Calendar[Date],"31/12")/(161.3333*MONTH(MAX(Calendar[Date])))
I have assumed the following:
Hi,
Try this measure
=CALCULATE([Billable hours],DATESYTD(Calendar[Date],"31/12")/(161.3333*MONTH(MAX(Calendar[Date])))
I have assumed the following:
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |