powerquery

Philip Trick 21 Feb 2021

Paid Members Public

QuickTip: Consolidate Excel Data

Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.

Philip Trick 29 Dec 2020

Paid Members Public

The Promise Of PowerQuery Custom Data Types

PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical data.

Philip Trick 01 Aug 2019

Paid Members Public

Quick Tip: Find The Missing (Data) Links

This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.