Please note javascript is required for full website functionality.

Power Query Blog Series

Power Query Blog Series

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

  1. A Refreshing Approach to ETL (get it?)
  2. Installing and Updating
  3. Getting Started
  4. Appending Files
  5. One Folder, One Query
  6. Painless Unpivoting
  7. What's in a Name?
  8. Relationship Goals
  9. (Data) Model Building
  10. Models Have Relationship Issues Too
  11. Two (Queries) Become One
  12. a World (Wide Web) of Possibilities
  13. Time for Refreshments
  14. M-Powered
  15. Unlimited Importing of Non-Delimited Text Files
  16. M-Body Personified
  17. Taking (Away) Steps for Efficiency
  18. A Summary Taster
  19. One Route to a Running Total
  20. Excel(lent) functions
  21. Calendar Creation – Preparing for Dates
  22. Calendar Creation – Going for Dates
  23. Aggregating Aggravating Worksheets
  24. Aggregating Aggravating Worksheets in Other Workbooks
  25. Group and Conquer
  26. Less Aggravating Aggregating
  27. Replace to Relocate – Simpler than Brexit
  28. Start and End with Grouping
  29. Viewing Query Dependencies
  30. Knowing Your Type is the Key
  31. Splitting Up is Not so Hard to Do
  32. I Just Want a Trim
  33. Uniting Different Types
  34. How Long Do We Have?
  35. in Terms of Conditional Columns.
  36. Passing Through Parameters
  37. Pivotal Pivoting
  38. Structured Columns Deconstructed
  39. Null and Not Void
  40. a Function Function
  41. Custom Built Functions
  42. In Your Face(book)
  43. Setting an Example
  44. Bring it to the Table
  45. If You Can’t Tell Them Apart, Join Them
  46. Initial Problems
  47. Managing Many Queries
  48. Get 2016 and Transform
  49. Expanding on Aggregating
  50. Birthday Lists
  51. Powering Through Issues
  52. Blanking the Blanks
  53. Pivot the Blanks
  54. Cleanse, Tone and Upload
  55. Powerless Pivot
  56. Customising Custom Built Functions
  57. Rapidly Renaming Columns
  58. Querying Query Options
  59. It’s Good to Share (a Query)
  60. Abridged Appending
  61. Evaluating Stored Queries
  62. Cell Referencing
  63. Setting a Better Example
  64. Returning to Referencing Ranges
  65. Passing (Reference to) Excel Parameters
  66. Sorry, Not on the List
  67. Moving Date
  68. Seedless Accommodating Accumulating
  69. Seeded Accommodating Accumulating
  70. Zipping Through a List
  71. Comparing Lists
  72. Join Me at the Table
  73. Hot Cross Joins
  74. Thanks for the Memory
  75. X Marks the Spot
  76. X Marks the Spot - Unleashed
  77. Splendid Splitting
  78. Candid Columns
  79. True Texting
  80. Tidy Texting
  81. Sub Texting
  82. Changing Dates
  83. Getting Something Out of a Date
  84. End of Dates
  85. Currently Dating?
  86. Technically Dating
  87. Seating Plans
  88. Upgrading Grades
  89. Joining Grades
  90. Upgrades
  91. Words are Key
  92. Excellent Examples
  93. Good Relations
  94. 10 Top Tips
  95. Erasing Errors
  96. Let It Be
  97. Group Dynamics
  98. Mind the Gap
  99. Presenting Text
  100. Appearing Cultured
  101. Building Bridges
  102. The Right Combination
  103. Merge Columns vs Merge Columns
  104. Different Standards
  105. Trying to Extract Errors
  106. Skip to the Good Part
  107. Update with Caution
  108. Linking Up
  109. Seeing JSON
  110. Skipping Lists
  111. A Join I Made Earlier
  112. Select a Number
  113. Conditional Column Splitting
  114. In the Zone
  115. Zoned Out
  116. File Away
  117. Fold(er) Away
  118. Find the Folder
  119. Value Added
  120. Extra Value
  121. Types of Value
  122. Functional Query
  123. Interactive Query
  124. Files for Today
  125. Exceptional Cases
  126. Absolutely Fabulous
  127. Divide and Conquer
  128. Fascinating Filters
  129. Today’s Calendar
  130. Check Today’s Calendar
  131. Fuzzy Matching
  132. Finding Fuzzy
  133. Is it on the Table?
  134. Are Any of Them on the Table?
  135. Durable Duplicates
  136. Reliable References
  137. Inquiring Minds
  138. Combining Forces
  139. Functioning Columns
  140. Step Back and See
  141. That Makes (Intelli)sense
  142. Name or Number
  143. Unique Combination
  144. Example Grading
  145. Rows of Columns
  146. Portable Document Format
  147. Grouping to the Max
  148. Top Tied
  149. Python Ready
  150. Python Set
  151. Python Go
  152. Learn by Example
  153. Check the List
  154. Emerging from Merging
  155. Time for a List
  156. Not Your Type
  157. The Wrong Type
  158. Fun with (Un)PivotTable
  159. More Fun with (Un)Pivot
  160. Even More Fun with (Un)Pivot
  161. Common Merging
  162. Solid Summary
  163. Group Functions
  164. Reconcilable Differences
  165. Sort it Out
  166. Overfill
  167. Next (Row) Please
  168. Next (Row) Again Please
  169. Next (Row) Once Again Please
  170. Dynamic Removals
  171. Empty
  172. Reorganising by Numbers
  173. Unique and Distinct
  174. Row by Row
  175. Table of Tables
  176. Ageing
  177. Big Comparison
  178. Folders Only
  179. Dynamic Merging
  180. Top Two
  181. Room for a View
  182. More Room for a View
  183. Previous Value
  184. Missing in Transformation
  185. Mind the Overlap
  186. Mind the Large Overlap
  187. Fiddly Fill Down
  188. Faster Fiddly Fill Down
  189. Fabulously Fiddly Fill Down
  190. The Delete Dilemma
  191. Which Way to Flip
  192. All Change for Values
  193. If Only
  194. Simply Conditional
  195. It Takes All Types
  196. Mad Max
  197. Mad Max Too
  198. ToolTip
  199. Picky Pivoting
  200. Almost There
  201. Going for the Record
  202. To Do List
  203. Update Your Calendar
  204. Expand Your Calendar
  205. Searching Questions
  206. More Searching Questions
  207. Recent Dates
  208. Space for a CamelCase
  209. All Dates Must Change
  210. I Gather That’s Right
  211. Divided Groups
  212. Options for Table Groups
  213. Timings
  214. New Year Function
  215. Pivot Problems
  216. Binary Function
  217. Part Time
  218. Keep on Running
  219. All Over Running Totals
  220. Don’t Miss Out
  221. Merging Muddles
  222. Emerging from a Muddle
  223. Self Merging
  224. Merging Matters
  225. Returning to the Folder
  226. More Merging Matters
  227. Flat Out
  228. Flat with a View
  229. Key Facts
  230. Dating Options
  231. Arranging a List
  232. Group Text
  233. Find a Table
  234. Folding Table
  235. Intelligent Folding
  236. Evasive Errors
  237. Three Sheets to the Table
  238. Fixed Expression
  239. A List of Distinct Possibilities
  240. Evaluate the Environment
  241. Faulty Filtering
  242. Totals by Type
  243. Tidier Totals by Type
  244. Rental Wrangles
  245. Refined Rental Wrangles
  246. Rental Wrangles Receipts - Part 1
  247. Rental Wrangles Receipts - Part 2
  248. Fruit Frustration – Part 1
  249. Fruit Frustration – Part 2
  250. Obstructed View
  251. PDF Pandemonium – Part 1
  252. PDF Pandemonium – Part 2
  253. PDF Pandemonium – Part 3
  254. PDF Pandemonium – Part 4
  255. PDF Pandemonium – Part 5
  256. PDF Pandemonium – Part 6
  257. Selective Staffing Part 1
  258. Selective Staffing Part 2
  259. Selective Staffing Part 3
  260. Selective Staffing Part 4
  261. Selective Staffing Part 5
  262. Selective Staffing Part 6
  263. Selective Staffing Part 7
  264. Riveting Results Part 1
  265. Riveting Results Part 2
  266. Riveting Results Part 3
  267. Riveting Results Part 4
  268. Riveting Results Part 5
  269. Riveting Results Part 6
  270. Riveting Results Part 7
  271. Riveting Results Part 8
  272. Riveting Results Part 9
  273. Riveting Results Part 10
  274. Totally Random
  275. Too Random
  276. Random Enough
  277. Google it
  278. Hidden Talents
  279. Sheets Ahead Part 1
  280. Sheets Ahead Part 2
  281. More Haste Less Steps Part 1
  282. More Haste Less Steps Part 2
  283. More Haste Less Steps Part 3
  284. More Haste Less Steps Part 4
  285. See it, Save it, Sort it - Part 1
  286. See it, Save it, Sort it - Part 2
  287. See it, Save it, Sort it - Part 3
  288. See it, Save it, Sort it - Part 4
  289. See it, Save it, Sort it - Part 5
  290. See it, Save it, Sort it - Part 6
  291. See it, Save it, Sort it - Part 7

Newsletter