Forum Discussion
Solved
Excluding after date using slicer
Hi, I have a scenario where I have patients who are in a care facility. These patients get various assessments done during their stay such as weight, BMI, blood pressure, cholesterol etc. I disp...
Hello MohammadLoran25 thank you for your suggestion.
I have solved this another way. What I did was to create a calculated column as follows:
Active = If(calculate(Values(Assessment_Period[EndDate]),filter(Assessment_Period, Assessment[Months] = Assessment_Period[Months])) > EOMONTH(calculate(Values(Patient[FileClosed]),filter(Patient, Assessment[PatientId] = Patient[Id])), 0), "No", "Yes")This determines at the row level in the assessment table if that particular assessment is for a patient who is no longer active.
Hello MohammadLoran25 thank you for your suggestion.
I have solved this another way. What I did was to create a calculated column as follows:
Active = If(calculate(Values(Assessment_Period[EndDate]),
filter(Assessment_Period, Assessment[Months] = Assessment_Period[Months])) > EOMONTH(calculate(Values(Patient[FileClosed]),
filter(Patient, Assessment[PatientId] = Patient[Id])), 0), "No", "Yes"
)
This determines at the row level in the assessment table if that particular assessment is for a patient who is no longer active.