Here is a complete list and respective links to all of our Power Query blogs:   

1. Power Query: A Refreshing Approach to ETL (get it?)
2. Power Query: Installing and Updating
3. Power Query: Getting Started
4. Power Query: Appending Files
5. Power Query: One Folder, One Query
6. Power Query: Painless Unpivoting
7. Power Query: What's in a Name?
8. Power Query: Relationship Goals
9. Power Query: (Data) Model Building
10. Power Query: Models Have Relationship Issues Too
11. Power Query: Two (Queries) Become One
12. Power Query: a World (Wide Web) of Possibilities
13. Power Query: Time for Refreshments
14. Power Query: M-Powered
15. Power Query: M-Body Personified
16. Power Query: Taking (Away) Steps for Efficiency
17. Power Query: One Route to a Running Total
18. Power Query: Excel(lent) functions
19. Power Query: Calendar Creation – Preparing for Dates
20. Power Query: Calendar Creation – Going for Dates
21. Power Query: Aggregating Aggravating Worksheets
22. Power Query: Aggregating Aggravating Worksheets in Other Workbooks
23. Power Query: Unlimited Importing of Non-Delimited Text Files
24. Power Query: Group and Conquer
25. Power Query: A Summary Taster
26. Power Query: Less Aggravating Aggregating
27. Power Query: Replace to Relocate – Simpler than Brexit
28. Power Query: Start and End with Grouping
29. Power Query: Viewing Query Dependencies
30. Power Query: Knowing Your Type is the Key
31. Power Query: Splitting Up is Not so Hard to Do
32. Power Query: I Just Want a Trim
33. Power Query: Uniting Different Types
34. Power Query: How Long Do We Have?
35. Power Query: in Terms of Conditional Columns.
36. Power Query: Passing Through Parameters
37. Power Query: Pivotal Pivoting
38. Power Query: Structured Columns Deconstructed
39. Power Query: Null and Not Void
40. Power Query: a Function Function
41. Power Query: Custom Built Functions
42. Power Query: In Your Face(book)
43. Power Query: Setting an Example
44. Power Query: Bring it to the Table
45. Power Query: If You Can’t Tell Them Apart, Join Them
46. Power Query: Initial Problems
47. Power Query: Managing Many Queries
48. Power Query: Get 2016 and Transform
49. Power Query: Expanding on Aggregating
50. Power Query: Birthday Lists
51. Power Query: Powering Through Issues
52. Power Query: Blanking the Blanks
53. Power Query: Pivot the Blanks
54. Power Query: Cleanse, Tone and Upload
55. Power Query: Powerless Pivot
56. Power Query: Customising Custom Built Functions
57. Power Query: Rapidly Renaming Columns
58. Power Query: Querying Query Options
59. Power Query: It’s Good to Share (a Query)
60. Power Query: Abridged Appending
61. Power Query: Evaluating Stored Queries
62. Power Query: Cell Referencing
63. Power Query: Setting a Better Example
64. Power Query: Returning to Referencing Ranges
65. Power Query: Passing (Reference to) Excel Parameters
66. Power Query: Sorry, Not on the List
67. Power Query: Moving Date
68. Power Query: Seedless Accommodating Accumulating
69. Power Query: Seeded Accommodating Accumulating
70. Power Query: Zipping Through a List
71. Power Query: Comparing Lists
72. Power Query: Join Me at the Table
73. Power Query: Hot Cross Joins
74. Power Query: Thanks for the Memory
75. Power Query: X Marks the Spot
76. Power Query: X Marks the Spot - Unleashed
77. Power Query: Splendid Splitting
78. Power Query: Candid Columns
79. Power Query: True Texting
80. Power Query: Tidy Texting
81. Power Query: Sub Texting
82. Power Query: Changing Dates
83. Power Query: Getting Something Out of a Date
84. Power Query: End of Dates
85. Power Query: Currently Dating?
86. Power Query: Technically Dating
87. Power Query: Seating Plans
88. Power Query: Upgrading Grades
89. Power Query: Joining Grades
90. Power Query: Upgrades
91. Power Query: Words are Key
92. Power Query: Excellent Examples
93. Power Query: Good Relations
94. Power Query: 10 Top Tips
95. Power Query: Erasing Errors
96. Power Query: Let It Be
97. Power Query: Group Dynamics
98. Power Query: Mind the Gap
99. Power Query: Presenting Text
100. Power Query: Appearing Cultured
101. Power Query: Building Bridges
102. Power Query: The Right Combination
103. Power Query: Merge Columns vs Merge Columns
104. Power Query: Different Standards
105. Power Query: Trying to Extract Errors
106. Power Query: Skip to the Good Part
107. Power Query: Update with Caution
108. Power Query: Linking Up
109. Power Query: Seeing JSON
110. Power Query: Skipping Lists
111. Power Query: A Join I Made Earlier
112. Power Query: Select a Number
113. Power Query: Conditional Column Splitting
114. Power Query: In the Zone
115. Power Query: Zoned Out
116. Power Query: File Away
117. Power Query: Fold(er) Away
118. Power Query: Find the Folder
119. Power Query: Value Added

  

 

 This list will be updated accordingly!