Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
aboliverABC
Frequent Visitor

Flagging an Auto Generated Record based on Date/Time

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. 

 

 

aboliverABC_0-1670600529670.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.