Power BI PowerQuery - Get the Latest Date using List.Max

Update as at 17 Apr 2022
Store the list as a buffer using List.Buffer
you will achieve even better performance.

Reference:

[thegroupgo]

Thank you for this clear and easy to grasp lecture

[eddyhugoariasborda]

Muchas gracias. Un nuevo suscriptor. Saludos desde Perú

[redlegcraig]

Thank you for this helpful tutorial. The same steps worked for me in Power Query within Power BI (Feb 2021 release)

[ardianug]

Hi kent..thx for tutorial..
How u calculate max just for special character, example...i just wanna search max date for A outlet? Or B?

[anatulyalmaimany]

This is what i was lloking for! Thank you so much!

[toodrunkfunk]

thank you so much Kent, couldn't find this anywhere.. really appreciate it!

[greghodgkinson]

Thank you for this video. It explained how to get the max date of a column using M Code.

[fenghu]

Thanks Kent it is exactly what I've been looking for!

[kc]

Awesome! This trick solved my problem. Thanks.

[chungnguyen_cop]

It's helpful indeed, thanks a lot❤

[thomasvandeweijer]

This was great, but what do you need to do when the maximum date for each outlet is different?

[artemtomchuk]

Please advise, how to get previous date before latest date?

[tryingtokool]

I am looking for the same thing in powerBI. trust we can use the same power Query.

[diegoasm]

how extract like one value? 18/06/2020