Skip to main content
AmigoFish

The Excel Tool That Does What PivotTables Can't Calculate

From MyOnlineTrainingHub · · 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

In this video, I’ll show you 3 common reporting problems regular PivotTables struggle with, and how Power Pivot solves them properly. 👩‍🏫 Take my Power Pivot and DAX course with 20% off until May 14, 2026: https://bit.ly/dax26course

⬇️ Download the example file here and follow along: https://bit.ly/dax26file

LEARN MORE ===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS ============== 0:00 Why your PivotTable can't handle real-world data 1:49 Turn on the feature Excel hides from you 2:18 Set up your data the right way 2:53 Connect 3 tables without a single lookup 4:46 Build one PivotTable from 3 separate tables 5:34 Write your first DAX measures 9:51 The invisible logic behind every DAX measure 11:27 The Excel skills companies are paying more for

#Excel #PivotTable #PowerPivot

Back to MyOnlineTrainingHub · Report a problem