Attendance out time

Hi rajasekar_o,

You can try to use the following calculated table formula to create a new table with the current table records based on empname, Date group and correspond in/out time values.

newTable =
SUMMARIZE (
    ADDCOLUMNS ( Table1, "Date", DATEVALUE ( [Datetime] ) ),
    [empName],
    [Date],
    "In Time",
        CALCULATE (
            TIMEVALUE ( MIN ( Table1[Datetime] ) ),
            FILTER (
                ALLSELECTED ( Table1 ),
                DATEVALUE ( [Datetime] ) = [Date]
                    && [Type] = 0
            ),
            VALUES ( Table1[empName] )
        ),
    "Out Time",
        CALCULATE (
            TIMEVALUE ( MAX ( Table1[Datetime] ) ),
            FILTER (
                ALLSELECTED ( Table1 ),
                DATEVALUE ( [Datetime] ) = [Date]
                    && [Type] = 1
            ),
            VALUES ( Table1[empName] )
        )
)

Regards,

Xiaoxin Sheng