Posts tagged #Templates

This One Change Made My Time-Intelligence [DAX] Performance Faster!

Video by: Reid Havens

Microsoft's new calendar-based time intelligence isn't magic, but it's a necessary optimization for every new model (and existing ones with performance issues).

The Results:
✅ Simplified query plans
✅ Fewer rows scanned by Storage Engine (SE)
✅ Same DAX, better syntax

The performance gains come from smarter query optimization. If you're working with large fact tables and time-based calculations, this is how the engine should be working.

What I cover:

How calendar-based functions optimize the storage engine
DAX Studio query plan comparison (side-by-side)
Setting up calendar categories in Power BI
Migrating from classic DATEADD to calendar-based syntax
FREE Power BI Calendar Template (PBIX)

(Livestream Replay) Intelligent Error Handing within Power Query - with Reza Rad

Hang out with us as Reza Rad and I talk about error handling within Power Query in Power BI Desktop (and also in Dataflows). We will discuss the situations when the error happens...but nothing is captured for troubleshooting! We will discuss and also go through demos of how to handle errors and create a troubleshooting report.

RELATED CONTENT 🔗

RELATED CONTENT 🔗

Blog Search

Subscribe

Subscribe to Access the Video Power BI Files!