in out time calculation

Hi rajasekar_o ,

Please follow these steps:

1.Creating intime measure.

intime =

VAR time = MAXX(FILTER(ALL('Table'),'Table'[ID] = MAX('Table'[ID]) && 'Table'[DATE ] = MAX('Table'[DATE ]) && 'Table'[TYPE] = "IN"),'Table'[TIME ])

RETURN

FORMAT(time,"hh:mm:ss")

2.Creating outtime measure.

outtime =

var cur_name=SELECTEDVALUE('Table'[ID])

var cur_dt=SELECTEDVALUE('Table'[DATE ])

var cur_date=DATE(YEAR(cur_dt),MONTH(cur_dt),DAY(cur_dt))

var next_date=cur_date+1

var tmp=FILTER(ALL('Table'),DATE(YEAR([DATE ]),MONTH([DATE ]),DAY([DATE ]))=cur_date&&[TYPE]="OUT"&&'Table'[ID] = cur_name)

var max_date=MAXX(tmp,[DATE ])

VAR time = MAXX(tmp,[TIME ])

var max_time=TIME(HOUR(time),MINUTE(time),SECOND(time))

var tmp2=FILTER(ALL('Table'),[ID]=cur_name&&DATE(YEAR([DATE ]),MONTH([DATE ]),DAY([DATE ]))=next_date&&[Type]="OUT")

var tmp3=FILTER(tmp2,[TIME ]<TIMEVALUE("8.00.00"))

var max_time1=MAXX(tmp3,[TIME ])

RETURN

IF(ISBLANK(COUNTROWS(tmp)),

FORMAT(max_time1,"hh:mm:ss"),

FORMAT(max_time,"hh:mm:ss")

)

3.Create another measure for filtering dates with only OUT.

Measure =

var _select=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[ID]=MAX('Table'[ID])&&'Table'[DATE ]=MAX('Table'[DATE ])),"Type1",[TYPE])

return

IF(

    "IN" in _select,1,0)

The settings inside filters are shown below.

4.The result obtained is shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.