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. More Merging Matters
  226. Flat Out
  227. Flat with a View
  228. Key Facts
  229. Dating Options
  230. Arranging a List
  231. Group Text
  232. Find a Table
  233. Folding Table
  234. Intelligent Folding
  235. Evasive Errors
  236. Three Sheets to the Table
  237. Fixed Expression
  238. Evaluate the Environment
  239. A List of Distinct Possibilities
  240. Faulty Filtering
  241. Totals by Type
  242. Tidier Totals by Type
  243. Rental Wrangles
  244. Refined Rental Wrangles
  245. Rental Wrangles Receipts - Part 1
  246. Rental Wrangles Receipts - Part 2
  247. Fruit Frustration – Part 1
  248. Fruit Frustration – Part 2
  249. Obstructed View
  250. PDF Pandemonium – Part 1
  251. PDF Pandemonium – Part 2
  252. PDF Pandemonium – Part 3
  253. PDF Pandemonium – Part 4
  254. PDF Pandemonium – Part 5
  255. PDF Pandemonium – Part 6
  256. Selective Staffing Part 1
  257. Selective Staffing Part 2
  258. Selective Staffing Part 3
  259. Selective Staffing Part 4
  260. Selective Staffing Part 5
  261. Selective Staffing Part 6
  262. Selective Staffing Part 7
  263. Riveting Results Part 1
  264. Riveting Results Part 2
  265. Riveting Results Part 3
  266. Riveting Results Part 4
  267. Riveting Results Part 5
  268. Riveting Results Part 6
  269. Riveting Results Part 7
  270. Riveting Results Part 8
  271. Riveting Results Part 9
  272. Riveting Results Part 10
  273. Totally Random
  274. Too Random
  275. Random Enough
  276. Google it
  277. Returning to the Folder
  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
  292. Keeping it Current – Part 1
  293. Keeping it Current – Part 2
  294. Keeping it Current – Part 3
  295. Double Access Savings – Part 1
  296. Double Access Savings – Part 2
  297. Double Access Savings – Part 3
  298. Double Access Savings – Part 4
  299. Check the Filters - Part 1
  300. Check the Filters - Part 2
  301. Re-returning to the Folder
  302. Steps to Take – Part 1
  303. Steps to Take – Part 2
  304. Steps to Take – Part 3
  305. Steps to Take – Part 4
  306. For Instance, Edit Two Queries
  307. Get Pasted – Part 1
  308. Get Pasted – Part 2
  309. Flexible Appending – Part 1
  310. Flexible Appending – Part 2
  311. Flexible Appending – Part 3
  312. Flexible Appending – Part 4
  313. Join or List – Part 1
  314. Join or List – Part 2
  315. Join or List – Part 3
  316. Join or List - Part 4
  317. Join or List - Part 5
  318. Join or List - Part 6
  319. Join or List - Part 7
  320. Expendable Expand
  321. Refreshing Challenges on the Web – Part 1
  322. Refreshing Challenges on the Web – Part 2
  323. Web Grouping
  324. Joining the dots
  325. Generating the A to Z of M Functions
  326. Questioning Queries
  327. Handling Dynamic Arrays
  328. Power Query Tables Do Not Have to be Green
  329. It Takes All Types
  330. It Makes All Types
  331. Total Refresh – Part 1
  332. Total Refresh – Part 2
  333. Project Population – Part 1
  334. Project Population – Part 2
  335. Project Population – Part 3
  336. Project Population – Part 4
  337. Project Population – Part 5
  338. Power Query Tables Don’t Have to be Green UPDATE
  339. Project Population – Part 6
  340. Project Population – Part 7
  341. Project Population – Part 8
  342. Project Population – Part 9
  343. Project Population – Part 10
  344. Project Population – Part 11
  345. Project Population – Part 12
  346. Project Population – Part 13
  347. Project Population – Part 14
  348. Template Tease
  349. Power Query Online – Part 1
  350. Power Query Online – Part 2
  351. Power Query Online – Part 3
  352. Power Query Online – Part 4
  353. Power Query Online – Part 5
  354. Power Query Online – Part 6
  355. Power Query Online – Part 7
  356. Power Query Online – Part 8
  357. Power Query Online – Part 9
  358. Power Query Online – Part 10
  359. Power Query Online – Part 11
  360. Power Query Online – Part 12
  361. Power Query Online – Part 13
  362. Excel Files from a Folder Fiddle – Part 1
  363. Excel Files from a Folder Fiddle – Part 2
  364. Excel Files from a Folder Fiddle – Part 3
  365. Blog List – Part 1
  366. Blog List – Part 2
  367. Blog List – Part 3
  368. Blog List – Part 4
  369. Blog List – Part 5
  370. Blog List – Part 6
  371. Equal Split
  372. Equal Split Part 2
  373. Equal Split Part 3
  374. Equal Split Part 4
  375. Equal Split Part 5
  376. Heading Off – Part 1
  377. Heading Off – Part 2
  378. Heading Off – Part 3
  379. Heading Off – Part 4
  380. Heading Off – Part 5
  381. Heading Off – Part 6
  382. Heading Off – Part 7
  383. Heading Off – Part 8
  384. Revision Time – Part 1
  385. Revision Time – Part 2
  386. Revision Time – Part 3
  387. Revision Time – Part 4
  388. Revision Time – Part 5
  389. Revision Time – Part 6
  390. Revision Time – Part 7
  391. Revision Time – Part 8
  392. Revision Time – Part 9
  393. Revision Time – Part 10
  394. Revision Time – Part 11
  395. Revision Time – Part 12
  396. Month Mayhem – Part 1
  397. Month Mayhem – Part 2
  398. Month Mayhem – Part 3
  399. Month Mayhem – Part 4
  400. Month Mayhem – Part 5
  401. Month Mayhem – Part 6
  402. Month Mayhem – Part 7
  403. Month Mayhem – Part 8
  404. Filtering of Choice Part 1
  405. Filtering of Choice Part 2
  406. Filtering of Choice Part 3
  407. Filtering of Choice Part 4
  408. It’s Good to Share(Point) Part 1
  409. It’s Good to Share(Point) Part 2
  410. It’s Good to Share(Point) Part 3
  411. It’s Good to Share(Point) Part 4
  412. It’s Good to Share(Point) Part 5
  413. It’s Good to Share(Point) Part 6

Newsletter