Time Intelligence in Power BI
summary
Shows how Power BI’s auto date/time creates multiple hidden calendars and why the fix is to disable Auto Date/Time and build a single date table (DAX, M, SQL or use Bravo date table). Demonstrates writing YTD with both DatesYTD vs manual CALCULATE+FILTER and shows the auto-all behavior that breaks weekday or custom-key relationships. Recommends trimming the calendar to needed granularity (month-only tables shrink rows and speed queries) and confirms custom DAX runs as fast as built-ins.
AI-written summary · about
chapters (17)
- 0:00Introduction to DAX
- 2:36Time intelligence concepts
- 3:43Auto date time risks
- 6:42Disabling auto date time
- 8:15Creating a calendar table
- 12:35Performance and Bravo
- 14:52Manual calendar creation
- 19:41YTD calculation logic
- 23:59Building manual YTD
- 27:31DAX function advantages
- 29:34Handling custom calendars
- 32:21Filter context behavior
- 35:54Date table relationships
- 39:28Mark as date table
- 41:45Handling complex filters
- 45:28Optimizing table size
- 48:05DAX patterns and wrap-up
related talks
48mTime Intelligence in Power BI
23mPower BI - Creating a M-agical Date Table
51mTroubleshooting Power BI Report Performance
28mPower BI Pointers
51mAggregations in Power BI
45mMagnificent 7 - Simple Tricks to boost your Power BI Development
51mOptimising DAX fusion - Power BI
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All