DAX Time Intelligence

What you’ll 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
Description
There is almost nothing you can do in Power BI that doesn’t involve some sort of time intelligence activity or the use of dates and/or time. This course provides a thorough study of how to get the most out of using, and understanding, dates in Power BI and the wealth of time intelligence features built into DAX.

In addition, you will learn how to create, and use, your own weekly calendar (4-4-5, 4-5-4 or 5-4-4) for those businesses that don’t use a traditional daily based calendar. You will also learn how to create, and use, a monthly based calendar which is common for budget data and aggregated sales data.