Master Power Query M Code and Data Shaping for Data Analysis

Master Power Query M Code and Data Shaping for Data Analysis

ExcelIsFun via YouTube Direct link

3. Files to download and follow along

3 of 67

3 of 67

3. Files to download and follow along

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Master Power Query M Code and Data Shaping for Data Analysis

Automatically move to the next video in the Classroom when playback concludes

  1. 1 1. Introduction
  2. 2 2. Why M Code?
  3. 3 3. Files to download and follow along
  4. 4 4. Power Query Editor
  5. 5 5. 3 Places to edit M Code
  6. 6 6. Introduction to let expression
  7. 7 7. Define Expressions
  8. 8 8. Introduction to the 15 M Code Values
  9. 9 9. Data Types, Type value
  10. 10 10. Operations and Data Types
  11. 11 11. identify Expressions in a let expressions
  12. 12 12. Change Data Type
  13. 13 13. Group By and Table.Group function, first example. Why list within a list is so useful!
  14. 14 14. Identifiers in M Code and why you never use spaces
  15. 15 15. Hack Group By dialog box to make calculations not in dialog box
  16. 16 16. Keywords
  17. 17 17. Editing in Advanced Editor, including Shift + Enter
  18. 18 18. Syntax for let expression
  19. 19 19. All 15 M Code Values and Operators that are allowed for each M Code Value
  20. 20 20. Null value
  21. 21 21. Logical value and formulas
  22. 22 22. Text value and formulas
  23. 23 23. Number value and formulas
  24. 24 24. Why it is important to use value type and not data type for determining whether an operation is valid.
  25. 25 25. Relationship between Values and Data Types
  26. 26 26. Colaesce operator or if expression when you have null values?
  27. 27 27. Custom Column and Table.AddColumn function
  28. 28 28. Time value and formulas
  29. 29 29. Date value and formulas
  30. 30 30. Date.AddDays function
  31. 31 31. Duration value
  32. 32 32. Duration.Days function
  33. 33 33. Power Query Dates 1/1/0001 to 12/31/999 and how they Rule: many examples!!!
  34. 34 34. Calculate hours worked through midnight. This is basis for custom function later in video
  35. 35 35. Number.Round function vs. ROUNDDOWN vs. INT
  36. 36 36. let expression to define variables in formulas
  37. 37 37. Convert ISO Dates to serial number dates
  38. 38 38. Using Locale feature: Convert dates and numbers from one locale France to another United Sates
  39. 39 39. Duration.Days vs. Duration.TotalDays functions
  40. 40 40. Datetime value and Datetimezone value
  41. 41 41. Table, list, record values can hold more than one M Code value
  42. 42 42. List value and formulas
  43. 43 43. Aggregate functions require lists
  44. 44 44. List to expand rows from improper data set with a range of years in cells
  45. 45 45. Record value and formulas
  46. 46 46. Generalized Identifiers
  47. 47 47. Table value and formulas
  48. 48 48. Binary value
  49. 49 49. M Code lookup
  50. 50 50. Row Index Lookup examples
  51. 51 51. Key Match Lookup examples
  52. 52 52. Excel.CurrectWorkbook function
  53. 53 53. Primary Keys and lookup
  54. 54 54. Lookup columns for aggregate functions
  55. 55 55. Merge feature and Join Operations: Left Outer, Inner, and Left-Anti
  56. 56 56. Function value: custom functions
  57. 57 57. Hours worked custom function
  58. 58 58. On Premine folder and file paths and Data Connections dialog box
  59. 59 59. Fix and Append Text Files custom function
  60. 60 60. Append tables with Table.ExpandColumns function
  61. 61 61. Append tables with Table.Combine function
  62. 62 62. each and underscore explained!
  63. 63 63. Approximate Match custom function
  64. 64 64. Table.Group function fourth argument: GroupKind
  65. 65 65. Table.Group function fifth argument: Comparer as function
  66. 66 66. Summary
  67. 67 67. Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.