Forum Discussion
Solved
Remove Duplicates and Sort Chronologically by row excluding specific columns
I have a table with columns for demographic information, vaccine date information and titer date/result information. By row, I need to remove duplicates and sort vaccine dates chronologically. I don'...
Thank you for your solution,
Unfortunately, I don't have access to DAX. However, I was able to come up with a very clunky and time consuming solution!
1. Reference the original table
2. Remove all the columns except "People Soft ID" and all the Vaccine date columns
3. Use the solution from this post from dufoq3
4. Remove empty columns found in this post
5. Merge this new table with the original.
This is my resulting code:
By row, I need to remove duplicates and sort vaccine dates chronologically. that is impossible unless they all take the same vaccinations in the same order.