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

az38 

Yes, I have created relationship on the Dates between the Calendar & the Fact [1 : *] .

Also, did all the steps including fetching the related column as a Result  in Fact table.

The issue is Dynamic SLA number (i.e. days) which in the Fact table occuring multiple times for a single date (as in my example).
Need a way to Add SLA as is,  at the step ' Add 10 working day step' without Aggregartion (i.e. Min/ Max)

 

Thanks.

 

 

Anonymous's avatar
Anonymous
Not applicable
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

    Thanks Anonymous   It worked perfect !