Forum Discussion
Solved
Duration
I'm looking for a way to calculate the number of days between when a Service Order status is "2-RECEIVED" to "5-QUOTED". We are looking to report the average it takes orders to go from Received to Q...
HI tmaki828,
You can use following measure to calculate datediff based on current 'document no' and 'before' 'after' fields tag:
Measure = VAR currNo = SELECTEDVALUE ( Table[Document No_] ) VAR list = CALCULATETABLE ( VALUES ( Table[Change Date] ), FILTER ( ALLSELECTED ( Table ), [Document No_] = currNo && [Before] = "2-RECEIVED" && [After] = "5-QUOTED" ) ) RETURN DATEDIFF ( MINX ( list, [Change Date] ), MAXX ( list, [Change Date] ), DAY )Regards,
Xiaoxin Sheng
