Get most recent data

[rosscortb]

Hello,

Can I do a get data from excel that only brings the rows against the most recent date?

Regards

Ross

[nandic]

@rosscortb ,

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

[jthomson]

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