Forum Discussion
Remove Duplicates and Sort Chronologically by row excluding specific columns
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:
Hi memote1,
Thank you for reaching out to the Microsoft fabric community forum. Thank you lbendlin, for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it. I have implemented the solution using DAX measures rather than Power Query (M code), as DAX offers a more transparent and manageable approach, especially for maintaining and enhancing the model over time.
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
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: