You've successfully subscribed to Explainly
Great! Next, complete checkout for full access to Explainly
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.
Home
Authors
Categories
Contact Us
PowerQuery Intro
PowerPivot Intro
M Language: Advanced PowerQuery
Log In
Sign Up
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.