By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
   / @wiseowltutorials  

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/power-bi/vi...

This video shows you how to get started with time intelligence functions in DAX. You'll learn how to make Power BI create a date table for each date column in your data model automatically. You'll also learn what the auto date table contains and why it's important for the operation of the time intelligence functions. You'll see how to display different levels of a date hierarchy and how to use the DateAdd function to modify the filter context applied to a measure to compare a calculation with past and future dates. Finally, you'll learn how to use the SamePeriodLastYear function as a shorthand for a specific use of the DateAdd function.

Chapters
00:00 Topic list
00:50 The Auto Date Time Setting
02:53 What the Auto Date Table Contains
05:55 Grouping a Measure by Years
07:28 The DateAdd Function
11:18 Showing Different Levels of the Hierarchy
14:02 Comparing to the Previous Year
14:50 Excluding Blanks
16:48 Comparing with the Previous Quarter
18:32 Using the IsFiltered Function
23:41 Comparing the Previous Month Using Variables
29:05 Using a Specialised Time Intelligence Function

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!