Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Expected Due/Completion Date Time based on SLA & Created Date Time

Hi, Looking for a help on DateTime Caculation. I have a table with Unique Tasks Ids and its allocated dateTime and each of it has an SLA in days defined. I need to create every Task's expected Com...
  • Anonymous's avatar
    Anonymous
    6 years ago

     

    QUOTIENT = QUOTIENT(WEEKDAY(Test[Allocate DateTime],1)+Test[SLA Days],7)
    Expected End Date = Test[Allocate DateTime]+Test[SLA Days]+2*Test[QUOTIENT]
     
    Thanks,
    Pravin
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Many thanks for your response Anonymous !

    I have tried that and the only issue is adding the Days to the Rank.

    In my case the value "10" is SLA and Dynamic coming from another Table, where the SLA for each datetime in the row.

    When I try to add it to the Rank (as the last parameter), it asks for aggrregation, where the output fails, since though the datetime it referes could be same but the SLA are different - (my table example above) !

     

    Appreciate your help on it ..

     

    Add 10 woring days = LOOKUPVALUE(Canlendar[Date],Canlendar[Identify],1,Canlendar[Rank1],Canlendar[Rank1]+10)

     

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      try something like

      +SELECTEDVALUE(YourTable[SLA Days])

      do not hesitate to give a kudo to useful posts and mark solutions as solution

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi az38 , Unfortunately SELECTEDVALUE() didnt work !

        Any other way you suggest ?

        Thanks