Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Prior Year to Date Billable

I'm trying to calculate the Prior Year to date for comparision   To get the Current YTD   YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]), DATESBETWEEN('Work Date'[Date],DATE(2021,11,...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    Anonymous 

    If you add a calendar table to your model you can us your existing meausre and the SAMEPERIODLASTYEAR like this.

    PYTD Billable = 
CALCULATE ( [YTD Billable], SAMESPERIODLASTYEAR ( Dates[Date] ) )
  • Anonymous's avatar
    Anonymous
    4 years ago

    jdbuchanan71 

     

    I'm not sure i put it in right I got the same numbers

    20/21 YTD Billable Hours = CALCULATE([YTD Billable], SAMEPERIODLASTYEAR('Work Date'[Date]))

     

     

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Anonymous 

If you add a calendar table to your model you can us your existing meausre and the SAMEPERIODLASTYEAR like this.

PYTD Billable = 
CALCULATE ( [YTD Billable], SAMESPERIODLASTYEAR ( Dates[Date] ) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

jdbuchanan71 

 

I'm not sure i put it in right I got the same numbers

20/21 YTD Billable Hours = CALCULATE([YTD Billable], SAMEPERIODLASTYEAR('Work Date'[Date]))