Contact Tracking List

[Anonymous]

Hi everyone,

I am trying to implement contact tracking in Power BI Desktop.

The data I have is:
people,
Date when the person was in the office

How can I output a list of people who were in the office at the same time as person X?

Any ideas?

Thanks,
Lh_2020

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data with the expected result to help us clarify your data structure and test to coding formula?

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , do you have office start and end time?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.