Forum Discussion
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...
- 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
Community Champion
Community ChampionAnonymous
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
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.
- 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
Thanks Anonymous It worked perfect !