Extract last row/occurrence | Power Query 01
In this video you will see how to get the last exchange rate or price in Power Query, be it a exchange rate or an instance related to a given value.
We'll need sorting, but most of all we'll be using the grouping options and the Table.LastN function in Power Query 01
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
--⏱️Timestamps⏱️--
00:00 | Intro
00:22 | Manuall search for a row
00:42 | Importing data to Power Query and sorting
01:36 | Grouping data - All rows option
02:48 | Last row - Table.LastN function
04:28 | Loading date to Excel and Summary
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelAndAdam #ExcelTips #excel