Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / How to filter a table to show only most recent date by group in Power Query – Part 1
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

How to filter a table to show only most recent date by group in Power Query – Part 1

Posted
Updated
ByRuth Pozuelo Martinez

It is a best practice to load in Power Bi only the data that you need. In today’s video, I will show you how you can filter a table by the last date available in Power Query.

Table of contents:

00:00 Intro
00:30 Explain the use case
01:00 The solution

Watch the tutorial:

How to filter a table to show only most recent date by group in Power Query

Links to the mentioned resources

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

Is this method too slow, try this:

Keep most recent record on a table with Power Query | Improved solution
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents