Sales VS Attendance

Hi gkalandadze ,

Here are the steps I followed

1. In the Attendance Table set the IN and OUT as TIME(HH:MM)

2. Sorted the Attendance Table by Employee

3. In the Sales Table set the TIme as TIME(HH:MM)

Added a calculated Column SalesMen  In SalesTable as
Salesmen =
VAR CurrentTime =
    FORMAT ( Sales[Time], "HH:MM" )
VAR SalesPerson =
    CALCULATETABLE (
        SUMMARIZE (
            UNION (
                CALCULATETABLE (
                    SUMMARIZE ( Attendance, Attendance[Employee] ),
                    FORMAT ( ( Attendance[IN] ), "HH:MM" ) >= CurrentTime
                ),
                CALCULATETABLE (
                    SUMMARIZE ( Attendance, Attendance[Employee] ),
                    CurrentTime <= FORMAT ( ( Attendance[OUT] ), "HH:MM" )
                )
            ),
            [Employee]
        )
    )
RETURN
    CONCATENATEX ( SalesPerson, [Employee], "," )

Atttached the Pbix

Cheers

CheenuSing