Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a set of data with multiple patients, where each patient has a set of records. I am trying to flag when a specific record is generated at the same time of another specific record for that patient. I only need to know when a "Triage" case was created at the same time as the "PAP" case. That patient may have multiple PAP caes, and may have multiple Triage cases. But I need to flag when the Triage Case was created at the same time as the PAP Case.
Solved! Go to Solution.
You can do that without code - have a table visual grouped by patient ID and datetime. Filter the events by Triage and PAP and filter your visual by rowcounts > 1
You can do that without code - have a table visual grouped by patient ID and datetime. Filter the events by Triage and PAP and filter your visual by rowcounts > 1
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |