Forum Discussion
Anonymous
7 years agoNot applicable
To calculate difference between In time and Out time for bio-metric report
Hi , I am designing a reports on biometric timimngs,but i am facing difficulties to find break timing. I am attaching a snapshot for more clarifiaction. 11:48:11 is shift timing and...
- 7 years ago
Hi Anonymous,
Please new such a measure:
Diff = VAR lastOUTTime = CALCULATE ( MAX ( TableA[Out Time] ), FILTER ( ALLEXCEPT ( TableA, TableA[Employee Code], TableA[Date] ), TableA[RNK] = CALCULATE ( MAX ( TableA[RNK] ), FILTER ( ALLEXCEPT ( TableA, TableA[Employee Code], TableA[Date] ), TableA[RNK] < MAX ( TableA[RNK] ) && TableA[Direction] = "OUT" ) ) ) ) RETURN DATEDIFF ( IF ( SELECTEDVALUE ( TableA[Direction] ) = "IN", lastOUTTime, BLANK () ), SELECTEDVALUE ( TableA[In Time] ), SECOND )Best regards,
Yuliana Gu
v-yulgu-msft
7 years agoMicrosoft Employee
Hi Anonymous,
Please new such a measure:
Diff =
VAR lastOUTTime =
CALCULATE (
MAX ( TableA[Out Time] ),
FILTER (
ALLEXCEPT ( TableA, TableA[Employee Code], TableA[Date] ),
TableA[RNK]
= CALCULATE (
MAX ( TableA[RNK] ),
FILTER (
ALLEXCEPT ( TableA, TableA[Employee Code], TableA[Date] ),
TableA[RNK] < MAX ( TableA[RNK] )
&& TableA[Direction] = "OUT"
)
)
)
)
RETURN
DATEDIFF (
IF ( SELECTEDVALUE ( TableA[Direction] ) = "IN", lastOUTTime, BLANK () ),
SELECTEDVALUE ( TableA[In Time] ),
SECOND
)
Best regards,
Yuliana Gu
Anonymous
7 years agoNot applicable
Hey v-yulgu-msft
Thank You.
Your formula worked but when i take multile userid's then it shows like :
Thanks & Regards,
Vivek Chavan