Forum Discussion
rosscortb
Post Patron
Post PatronGet most recent data
Hello, Can I do a get data from excel that only brings the rows against the most recent date? Regards Ross
jthomson
Solution Sage
Solution SageYep. 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