Forum Discussion

okusai3000's avatar
okusai3000
Helper IV
6 years ago
Solved

Two dates and USERELATIONSHIP

Hello everyone,   I'm getting nuts trying to solve the following.   I have a table with VISITS to PATIENTS.  Each visit is related to a PATIENT_ID. Could happen that you have 2 visits to the s...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    Hello okusai3000 

     

    Try this:

    Form Not Signed = 

VAR _SignFormDateChek = 
    FILTER(dtPatient,
    ISBLANK(dtPatient[[CON_VIS_CLI]) || dtPatient[[CON_VIS_CLI] > dtPatient[Vistit Date]
    )
    
VAR _RowCount = 
    CALCULATE(DISTINCTCOUNT(dtPatient[PATIENT_ID]),_SignFormDateChek
    )
RETURN
_RowCount

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution
    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    Connect on LinkedIn

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi okusai3000 

Could you show a simple example and expected result to make me clear?

 

Best Regards

Maggie