DAX Time Intelligence

Master DAX time intelligence functions and analysis

Created by: Randy Minder
Lead BI Developer / Power BI / Microsoft Fabric

What Will I Learn?

• How dates are handled and manipulated in DAX
• Creating and using a traditional daily non-fiscal calendar table
• Creating and using a daily fiscal based calendar
• Creating and using a weekly based calendar table
• Creating and using a monthly based calendar table
• Using the built-in DAX time intelligence functions against a daily calendar table
• Exploring daily, weekly and monthly techniques against real-world sales data

Requirements

• Some basic working experience with DAX

Target audience

• All DAX developers