Easily Extract Data from Power Query Lists and Records - My Online Training Hub
FBTwitterReddit
video description
Rating: 4.5; Vote: 2
Easily Extract Data from Power Query Lists and Records - My Online Training Hub
Lists and Records are a key component of working with Power Query. You may have seen them when getting data from SharePoint or an API. In this video we'll show you how to easily extract the data with a Custom Column.
Download the Excel file: https://www.myonlinetraininghub.com/extracting-data-from-lists-and-records-in-power-query
Learn Power Query with Mynda here: https://www.myonlinetraininghub.com/excel-power-query-course
0:22 Get data from Lists
3:16 Get data from Records
5:56 Get data from Lists & Records
Jim: Great tutorial. And timely, too. I especially liked the third example that has a single step that produces combined result whether source data are Lists or Records. A simple nested if-then-else, but clever. Date: 2022-04-08
