Forum Discussion

jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Formula for pulling most recent patient visit

Hello! Looking for help to create a formula that will bring back the most recent patient visit.  For example, I have an excel file with 20,000 patient names, many of the patients are listed multiple...
Need Help
  • jonnyA's avatar
    jonnyA
    5 years ago

    Thanks to everyone who responded!

    I figured out the answer ...

    Max Date = (MAX('ApptDetail'[Appt DateTime]))
BI_Jo's avatar
BI_Jo
Icon for Resolver III rankResolver III
5 years ago

Hi 

 

I would create a latest visit column using the following DAX and use the column as a filter on your report:

LatestVisitColumn =
if('TableName'[Appt DateTime] = CALCULATE(MAX('TableName'[Appt DateTime]),
ALLEXCEPT('TableName','TableName'[Patient ID Field])), "Yes", "No")

The column will say "Yes" if it is the patients latest visit. 
 
Hope that helps
Jo