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

and here it is how to filter N records:

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.

Chapters:
00:00 Intro
00:30 Explain the use case
01:00 The solution
Done!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[davida.taylor]

This was perfect. Came in super-handy today. There are always new tricks to learn. Thank you for creating and publishing this!

[marianarossicampos]

Ruth! What a star! I spent the last two hours of my Friday trying to fix this, it was on the back of my mind all weekend, now it's Monday morning at 7:41 a.m. and there you go! Fuiste la única que realmente pudo ayudarme. Very well explained, step by step, and it worked wonders. You've got another follower :D

[hugomancera]

Curbal, what would we do without your videos?! Que harÍamos sin tus videos!? ERES GENIAL !!! YOUR A GENIOUS !!!

[yepilemoy]

I just want to let you know how many times you've saved me from different problems I encountered. Half of the solutions in my everyday tasks comes from your channel. Thank you! <3

[bc]

So useful. Thank you! I used this approach to pare down a Refreshes dataset from the Power BI service and then report on the last successful refresh.

[acronymskateshop]

I truly appreciate your content. I'll never meet you but I think of you as a helpful friend who explains things very patiently and thoroughly without going too deep into the weeds. Thanks so much!

[dion]

You have no idea how long I struggled with this, and stumbled on your channel and this is a featured video! Life changing!

[IntegratedEnvironmentalSolutio]

I love when I find the exact walkthrough I need on the first search! Thank you very much for the quick and clear explanation!!

[nicoi]

Simply fantastic! I spent almost an hour looking for an elegant solution to this problem, and you did it again!

[ragnareiriksson]

As always - brilliantly explained. A suggested addition to this would be to merge the MaxDate table back with the original, creating a "Is latest" boolean column. I'm confident I can work it out but everything is easier when you explain for us.

[nicklea]

Amazing, thank you! This is perfect for what I needed. I'd seen a few blog posts about this but it was done in such a convoluted way. You kept it simple and easy, brilliant.

[clacby]

BRILLIANT!!! You answered my question before I made it to myself, thanks a lot

[uberleetmike]

This was exactly what I needed! Also video was clear and concise. Thank You!

[Ben-ldlt]

This is such smart way. I tweaked your method and removed duplicates with several conditions! Thanks!

[vrecording]

Brilliant. So well explained. You saved me so much time on a project. Thanks

[wants]

Awesome. I followed all the steps and worked perfect. You have no idea how much I've been looking for this solution. THANK YOOUUU

[nicoymartina]

Awesome solution. Very useful. Thanks again, Ruth!

[elizabethtompsett]

Ruth - you are wonderful, this is exactly what I needed for forecasting data, thank you for all the videos you post

[poojasahasrabhojanee]

Hey Ruth,
You are my fairy who solves the problems using her magic. You are super awesome. Thank You so much :) :)

[martinwambuidataanalyst]

I really apprreaciate the effort you made to save me from a problem that I had encountered for continuous one week.
May you live long