New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Keep most recent record on a table with Power Query | Improved solution – Part 2

I have shown you before how to filter a table by its most recent record before, but I have found a cleaner and I think more effective way to do it. (Test both versions to see what works with your data)

Watch the tutorial:

Keep most recent record on a table with Power Query | Improved solution

Links to the mentioned resources

To get the files:
1. Go to Curbal Download Center > Community Downloads
2. Get File #67

And here is the previous method I showed you:

How to filter a table to show only most recent date by group in Power Query
Was this helpful?
Previous How to filter a table to show only most recent date by group in Power Query – Part 1
Next Import tables or pages based on a word or phrase from a pdf in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents