What You Will 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
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.
We then bring all this knowledge together and demonstrate how to use daily, weekly and monthly date techniques on real-world sales data to build common types of reports using daily, weekly or monthly calendars.
Who Should Attend!
- All DAX developers
