Forum Discussion
Modifying Turnaround Time to be more Dynamic
Hi. I have a question related to the calculation (Dax formulas) for SLA metrics on the processing time for Purchase Orders. This is one of them: Time_Turnaround = NETWORKDAYS([Created],[Completi...
Anonymous
In our example the 1st one is 5 AM so 4 days is correct, the 2nd one should be 3. I modifed to include 5 as well using >=, please checkTime_Turnaround = VAR __Time = HOUR([Created]) VAR __Diff = NETWORKDAYS([Created],[CompletionDate/Time],1,Distinct(HolidaysTable[Holiday])) VAR __Result = IF( __Time >= 17 , __Diff - 1 , __Diff ) RETURN __Result
Thank you Fowmy The DAX correction works. However, the 2 records that were created on 12/5 after 5pm, which means they should have been considered as received on 12/6, so turnaround time (completed on 12/8) should be 3 days, but they are showing 4 days. Can you tweak the turnaround time DAX to resolve that? Thanks so much!
Anonymous
In our example the 1st one is 5 AM so 4 days is correct, the 2nd one should be 3. I modifed to include 5 as well using >=, please checkTime_Turnaround = VAR __Time = HOUR([Created]) VAR __Diff = NETWORKDAYS([Created],[CompletionDate/Time],1,Distinct(HolidaysTable[Holiday])) VAR __Result = IF( __Time >= 17 , __Diff - 1 , __Diff ) RETURN __ResultFowmy You are a GENIUS! Yes that worked! Thank you a bajillion!