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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 19 | |
| 17 | |
| 11 |