DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions

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: https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join 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/videos/dax-powerbi/dax-intro-time-intelligence/ 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!