Forum Discussion
Get most recent data
Hello, Can I do a get data from excel that only brings the rows against the most recent date? Regards Ross
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