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 

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

  • 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.

       

       

    • 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