Description
By Sam Lowrie
In Power Query for Excel and Power BI, you can use the Power Query M Formula Language (or M for short) to manipulate data before it’s loaded. In this webinar, we explore some of our favourite M use cases, from creating tables to removing null columns.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel by clicking the following link:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Chapters
00:00 Introduction
01:50 Using Buffer with remove duplicates
05:00 Add missing columns
19:25 Change column data types
29:00 Remove blank columns
35:30 Creating tables from array structure
44:25 Convert lists to single table
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!