Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Today's Date + measure (integer)

I've created a measure that projects the number of days left to complete a project

 

Projected number of days till completion = backlog/average worked per day

 

I'm wanting to return today's date + projected number of days till completion

for example: today's date + 5 and i want it to return in a (1/11/1111) if possible Thank you ! 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous 

    Try like

    Measure = Today +5

     

    Or

    measure =

    var _1 = maxx(Table,Table[Col])

    Return

    Measure = Today +_1

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I'm wanting to take into account working days

       

      What I want: 

      Projected date = Today + measure 

      so if it was a thursday and the measure output was 2 I would want to display monday's Date , 2 being + 2 working days not calendar days

       

      Sorry if i was vague, i'm wanting to Add the measure (projected number of days till completion) to today's date but in terms of working days to exclude weekends

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    You can create a table with working dates only based on the calendar. Then used that column as the data column.

    Table 2 = CALCULATETABLE('Table',FILTER('Table',WEEKDAY([Date],2)<>6 && WEEKDAY([Date],2)<>7))

     

    Paul Zheng