Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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
@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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |