🪄🐈⬛ TnT #5 🧨
This article covers how to transform a list of records into a table of correctly typed columns in a single Power Query M action step. The solution involves combining the type table declaration with the square bracket shorthand for records in the column names parameter of the Table.FromRecords function. The article also mentions some useful intrinsic functions for Power Query, including #date, #datetime, #datetimezone, #duration, #time, and #table.
Article 22m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time