Hours needed by remaining Months in the billable year

[Anonymous]

Hi I'm trying to write a measure that would show me how many hours are need each month to get to an expected billable. 

I work at a law firm and the billable year is 2020-11-1 to 2021-10-31. 

I have a measure that tells me the expected hours, I  have another measure that tells me how many hours has be worked hour has been billed to date

I created a measure 

Hours Needed = CALCULATE([2021 Expected Hours]-[2021 Billable Hours])- This tells me how many hours they need to get to the expected hours. 

But now I want to divide that by the number of months left in the billable year and this is where I'm getting lost.  I know there are three months left this year but is there a measure I could write that would 

Example would be 

2021 Expected Hours 2000

Year To Date Hours 1320

Hours need- 680

I want a measure that would break down the 680 to how many hours is needed for the remainding months.  I know I can just divide the 680/3 but is there a measure that would calculate the remaining months for me. 

Thanks

[VahidDM · Accepted solution]

Hi @Anonymous 

You can use "DATEDIFF" DAX code.

Try this measure:

remaining months =
VAR _Today =
    TODAY ()
VAR _ENdOfBY =
    DATE ( YEAR ( _Today ), 10, 31 )
VAR _RD =
    DATEDIFF ( _Today, _ENdOfBY, MONTH )
RETURN
    IF ( _Rd < 0, ABS ( _RD ) + 10, _RD )

It will calculate the remaining month between Today and end of  billable year, so now it will return 2 because we are in the middle of August, so if you want to consider the current month in your calculation (to return3), just add +1 at the end of the last row [ IF ( _Rd < 0, ABS ( _RD ) + 10, _RD )+1].

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[Anonymous]

@VahidDM Thank you