Covid contact tracing

[avinrosh]

I am lookng for a dax query which will be used for contact tracing. We are maintaing a dashboard which records check-in check-out time of an employee for a given date. Let's say one employee gets tested posiive for Covid, then I will go to the dashboard. Enter that employee name and salect the date.

Based on this a table will be returned which will show up the list of the empoyees who were in the office during the period the affected employee was also present. The presence of the employee is determined by the check in check out time of he employees.