Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

YTD Measure

I'm able to calculate YTD 

 

by using the following measure 

YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], DATE(2021, 1,1), TODAY())), but I wanted to automate it so I don't have to update it every year, I wrote the below but I'm not getting any results. any suggestions.

 

YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], DATE(YEAR(TODAY()), MONTH(1), 1), TODAY()))
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Anonymous 

    here you go,

     

    YTD Billable =
    VAR  _Date = SELECTEDVALUE('Work Date'[Date])
    RETURN
    CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], _Date , TODAY()))

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi Anonymous 

    replace DATE(YEAR(TODAY()), MONTH(1), 1), TODAY())) by TODAY()).

     

    YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], TODAY()))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      aj1973, I'm sorry it didn't work I'm not quite sure what I'm replacing. The "by Today shows an error and 

       

      YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], TODAY()))- is showing an error becasue there is no end date

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        Anonymous 

        here you go,

         

        YTD Billable =
        VAR  _Date = SELECTEDVALUE('Work Date'[Date])
        RETURN
        CALCULATE(SUM(Utilisation[ChargeableHours]),DATESBETWEEN('Work Date'[Date], _Date , TODAY()))