Play all

1. Introduction

2. Define M Code

3. Power Query and M Code are in Both Excel and Power BI Desktop

4. Advanced Editor button in Excel & Power BI Desktop

5. Power BI Desktop “Enable Load”

6. M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We use a Group By Query to learn about the basics of M Code.

7. M Code Identifiers and spaces.

8. let expression definition and structure.

9. Expressions

10. Insert or Delete Query let expression Steps: 2 possibilities.

11. #shared to show Standard Library in Power Query

12. Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type

13. IF function and AND Function in M Code

14. Compare Excel Close & Load to Power BI Desktop Close & Apply

15. Copy and Paste Tables into Power BI Desktop.

16. Power Query Date and Duration Examples

17. Table Values

18. Record Values

19. List Values

20. Binary, Function and Type M Code Values

21. Data Types

22. Values Vs. Data Types

23. M Code Lookup: Two-way Lookup, Column Lookup, Row or Record lookup. Also know as: Projection lookup column and Selection lookup row

24. Diagrams for M Code Lookup

25. Row Index Lookup

26. Key Match Lookup

27. Drill Down, Primary Keys and Lookup

28. Custom Functions 5 examples to learn basics

29. Build reusable function.

30. Build Custom Function as a Query Step.

31. each and Underscore.

32. Approximate Match Lookup M Code Custom Function 4 examples

33. Full Video Summary and Conclusions

34. Closing and Video Links

Description:

Dive into a comprehensive video tutorial on M Code for Power Query in Excel and Power BI, ranging from basic to advanced concepts. Learn about M Code fundamentals, Power Query Editor, let expressions, data types, and various M Code values. Explore advanced topics such as lookups, custom functions, and approximate match techniques. Gain practical skills through numerous examples and hands-on exercises, guided by Excel MVP and Highline College Professor Mike Girvin. Perfect for data analysts and Excel power users looking to enhance their data manipulation and transformation capabilities.

M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions

ExcelIsFun

Add to list

#Business #Business Intelligence #Microsoft PowerApps #Business Software #Microsoft Office 365 #Microsoft Excel #Microsoft Power BI

0:00 / 0:00