Adding Is Latest flag in Power Query and how to build up formulas from the User Interface

[@GeertDelmulle]

Very good lesson!!
This is exactly the way we grow and become more Power Query savvy.
People that aspire to become intermediate users should watch this video!

[@AccessAnalytic]

Thanks for the kind comment Geert

[@Olu_boomie]

Brilliant, absolutely brilliant! You just got a new subscriber Wyn.

[@AccessAnalytic]

Thanks for joining us 😄

[@NarendraSunku]

This is brilliant, Wyn! Thank you for sharing.

[@AccessAnalytic]

No worries, thanks for the kind comment

[@IvanCortinas_ES]

Great video Wyn! Thank you for sharing it.

[@AccessAnalytic]

You’re welcome Ivan

[@CeliaAlvesSolveExcel]

Love it, Wyn! Thank you for sharing this.

[@AccessAnalytic]

You're welcome Celia 😀

[@romeocostillas]

And this is why I love to visit your channel because I am learning a lot of things esp in PQ. Thanks again Wyn for a nice tutorial, will wait for your next videos.. good luck and God bless

[@AccessAnalytic]

Thank you for letting me know. I really appreciate it

[@GrainneDuggan_Excel]

Wow. So useful. Thanks Wyn

[@AccessAnalytic]

Thanks for letting me know Grainne 😀

[@zzzzzzzzzzzzzzzz9]

Yes thank you. I'm learnin PQ so good to get tips and thought processes

[@heidihasting6232]

awesome, thanks Wyn

[@AccessAnalytic]

No worries Heidi, thanks for the feedback

[@amanfinch]

Great tutorial, how would I flag the latest date in each Item?

[@AccessAnalytic]

If you use the Group By button you can use the advanced option to add an aggregation to get the Max date for each grouped item

[@amanfinch]

@@AccessAnalytic that's awesome, thank you for the quick response too!

[@FredericLEGUEN-Excel]

Brilliant Wyn. Nice trick with Ctrl + Shit + '+' to Zoom in 😀👍

[@AccessAnalytic]

Thanks 😀

[@JonathanExcels]

Helpful.

[@AccessAnalytic]

Thanks Jonathan