Matthias Friedmann

Power Query

Power Query Challenge

data solutions

optimized solutions

Power BI

data cleaning

dynamic queries

query challenges

list.generate examples

power query list.generate

list.generate running total

running total

data challenges

optimise query

query optimization

transforming data

data optimization

query techniques

data transformation

query tips

get data

Become a Power Query master with walkthroughs of advanced data challenges! Get step-by-step instructions on easily accessible solutions: Learn how to use the user-friendly UI to solve even complex data problems without having to code in M.

Data is often a challenge to access, scattered across multiple sources and formats, and messy. That's where the power of Power Query comes in: Say goodbye to tedious data processes and unlock the full potential of YOUR data with Power Query in Excel and Power BI. Automate repetitive tasks and make the most of your valuable time.

► Subscribe now and let's conquer the data challenges together!



As an Excel & Power BI pro (🏆 Enterprise DNA Expert) with deep expertise in planning & reporting methods in the automotive industry, I understand the challenges of applying YouTube learnings to your specific data:
📣 Contact me on LinkedIn to explore how we can create a customized coaching plan for YOUR unique data challenges.

Mastering Power Query: List.Generate & Lookups Explained

Mastering Power Query: List.Generate & Lookups Explained
2 Must-Know Power Query Tricks: Add Dynamic Blank Rows

2 Must-Know Power Query Tricks: Add Dynamic Blank Rows
Power Query: How to use List.Generate for Multiple Running Totals

Power Query: How to use List.Generate for Multiple Running Totals
Power Query Made Easy: 2 Essential Tricks for Cartesian Product & Filter Logic

Power Query Made Easy: 2 Essential Tricks for Cartesian Product & Filter Logic
Power Query: Find Top and Bottom Entries with List.Max & List.Min

Power Query: Find Top and Bottom Entries with List.Max & List.Min
Power Query: Find Maximum Occurrences across Columns

Power Query: Find Maximum Occurrences across Columns
Power Query: How to Duplicate Rows (and Split Amounts)

Power Query: How to Duplicate Rows (and Split Amounts)
Easily Reverse Rows AND Columns in Power Query: 4 Quick Clicks

Easily Reverse Rows AND Columns in Power Query: 4 Quick Clicks
Find Missing Numbers in Power Query (with UI Support!)

Find Missing Numbers in Power Query (with UI Support!)
Power Query: Replace Letters in a String (Step-by-Step!)

Power Query: Replace Letters in a String (Step-by-Step!)
Simple List.Generate in Power Query: Master the

Simple List.Generate in Power Query: Master the "Do Until Loop" Easily
How To Align Data with Power Query: Merge & Append Tricks

How To Align Data with Power Query: Merge & Append Tricks
Power Query: The EASIEST Running Total & Count Methods (Conditional!)

Power Query: The EASIEST Running Total & Count Methods (Conditional!)
Advanced Group By in Power Query: Learn to Rank Like a Pro

Advanced Group By in Power Query: Learn to Rank Like a Pro
The Magic of Custom Functions in Power Query: Solve the Common Meeting Challenge

The Magic of Custom Functions in Power Query: Solve the Common Meeting Challenge
Power Query: Effortlessly Pair Teams with List.Skip & Index!

Power Query: Effortlessly Pair Teams with List.Skip & Index!
Power Query: Identify Palindromes FAST (2 Easy Text.Reverse Tricks!)

Power Query: Identify Palindromes FAST (2 Easy Text.Reverse Tricks!)