'Power BI Column showing T/F
I am looking to create a column in Power BI that will display a T/F only on the first instance of a [Patient_ID]. However, I also want to include a filter to only show the ones which have a [Visit_Status_Code] of CHK. I have attempted a few different iterations, and here is what I have so far. It is not excluding the other status codes, as I need it to.
New_Pt? =
COUNTROWS(
FILTER(
'Appointments',
Appointments[Patient_ID] = EARLIER(Appointments[Patient_ID]) &&
Appointments[Visit_Status_Code] = "CHK"
)
) =1
I would appreciate any help seeing where my errors are
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
