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...
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))
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))