Get most recent data

Yep. In Power Query, make a custom column that looks like this:

Date.From(List.Max(nameofpreviousstepinquery[yourdatefield]))

That should populate all your data with the most recent date - you can compare your new field and see if it matches with the original date field, and then filter out where it doesn't

rosscortb ,

You can filter table based on date - choose today filter.
It will return only rows matching 9/24/2020 in this case.