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
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

did you create relationships?

did you try 

Result=RELATED(Calendar[Add 10 woring days])

as mentioned in example?

Add 10 woring days is a column from Calendar table

 

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 Anonymous 

 

Did you tried my solution?

 

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.