Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Previous year error

I'm trying to calculate the total hours but from the date November 1, Previous Year to Today. 

 

AA YTD Billable Hours = CALCULATE(SUM(SQL[Billable]), DATESBETWEEN(SQL[workacctperiod].[Date], DATE(TODAY()-1, 11,1), Today()))
 
However, I am recieving an error
 
 
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    plse try this

    AA YTD Billable Hours = 
VAR _ToDay = Today()
RETURN
CALCULATE(SUM(SQL[Billable]), 
     DATESBETWEEN(SQL[workacctperiod].[Date], DATE(YEAR(_ToDay)-1, 11,1), 
           _ToDay))

1 Reply

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    plse try this

    AA YTD Billable Hours = 
VAR _ToDay = Today()
RETURN
CALCULATE(SUM(SQL[Billable]), 
     DATESBETWEEN(SQL[workacctperiod].[Date], DATE(YEAR(_ToDay)-1, 11,1), 
           _ToDay))