Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 times because they had multiple visits. How would I create a formula that will only bring back the most recent visit? Below are the fields I am using. Thank you in advance!
Solved! Go to Solution.
Thanks to everyone who responded!
I figured out the answer ...
Thanks to everyone who responded!
I figured out the answer ...
Hi
I would create a latest visit column using the following DAX and use the column as a filter on your report:
@jonnyA , Create a measure like this and try
Measure =
VAR __id = MAX ('Table'[Patient Last Name, First Name] )
VAR __date = CALCULATE ( MAX('Table'[App Date Time] ), ALLSELECTED ('Table' ), 'Table'[Patient Last Name, First Name] = __id )
CALCULATE ( MAx ('Table'[App Date Time] ), VALUES ('Table'[Patient Last Name, First Name] ),'Table'[Patient Last Name, First Name] = __id,'Table'[App Date Time] = __date )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |