Forum Discussion
Create Array lookup in Query
I am trying to measure TAT. To do so, I need to calculate how long an item was in each queue using only the time an item entered each queue. In excel, I used an array to return the min Entered Qu...
You can use this calculated column:
= CALCULATE ( MIN ( Table1[Entered Queue] ), ALLEXCEPT ( Table1, Table1[Name] ), Table1[Entered Queue] > EARLIER ( Table1[Entered Queue] ) )
LivioLanzo
Solution Sage
Solution SageYou can use this calculated column:
=
CALCULATE (
MIN ( Table1[Entered Queue] ),
ALLEXCEPT ( Table1, Table1[Name] ),
Table1[Entered Queue] > EARLIER ( Table1[Entered Queue] )
)LivioLanzo,
Its so simple and beautiful. It works perfectly. Thank you!