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 www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Download files here www.wiseowl.co.uk/power-bi/vi...
This video explains how to use DAX time intelligence functions to modify the filter context applied to a measure, allowing you to compare calculations for different time periods. You'll learn the differences between the DateAdd, SamePeriodLastYear, PreviousYear and ParallelPeriod functions. You'll also see how to enter specific dates using the DateValue and Date functions, and how to use these dates in the DatesBetween function. Finally, you'll learn how to calculate moving averages using FirstDate and LastDate functions and the DatesInPeriod function.
Chapters
00:00 Topic list
00:45 Importing Data and Creating a Basic Report
03:54 Comparing with the Previous Year
07:26 The PreviousYear Function
09:00 Differences Between Time Intelligence Functions
11:26 Comparing Previous Quarters
13:50 What's in a Name?
15:19 Calculating Percentage of Previous Year Total
17:14 The ParallelPeriod Function
20:16 Calculating the Total of the Same Year
21:45 Entering a Specific Date Range
26:39 Checking a Date Range Using Filters
28:16 Calculating the First and Last Date of a Period
31:12 Adjusting the First Date with DateAdd
32:16 Calculating the Moving Average using DatesBetween
33:18 Using the DatesInPeriod Function
Visit 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!
5 авг 2024
