DAX Time Intelligence

DAX Time Intelligence

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.

Master DAX time intelligence functions and analysis

Url: View Details

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

Rating: 4.45

Level: All Levels

Duration: 4.5 hours

Instructor: Randy Minder