Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help Calculating YTD Utilization by Month

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 mont...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this measure

    =CALCULATE([Billable hours],DATESYTD(Calendar[Date],"31/12")/(161.3333*MONTH(MAX(Calendar[Date])))

    I have assumed the following:

    1. Billable hours is a measure
    2. There is a Calendar Table with a column of Year and Month.  The Dates in the Calendar Table should run until the last date in the Date column of your Data Table
    3. There is an active relationship from the Date column of your Data Table to the Date column of the Calendar Table
    4. To your visual, you have dragged Year and Month from the Calendar Table
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Try this measure

=CALCULATE([Billable hours],DATESYTD(Calendar[Date],"31/12")/(161.3333*MONTH(MAX(Calendar[Date])))

I have assumed the following:

  1. Billable hours is a measure
  2. There is a Calendar Table with a column of Year and Month.  The Dates in the Calendar Table should run until the last date in the Date column of your Data Table
  3. There is an active relationship from the Date column of your Data Table to the Date column of the Calendar Table
  4. To your visual, you have dragged Year and Month from the Calendar Table