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-rolling-average/

This video shows you how to calculate rolling or moving average calculations in DAX. You'll learn how to use the DATESINPERIOD function to expand the date range over which an average is calculated, specifying the number of years, quarters or months. You'll also see how to work out the average of other aggregations such as a yearly, quarterly or monthly sum of a value. You'll see how to handle blank values using the COALESCE function. Finally, you'll learn how to use a numeric range parameter to allow the end user to control the period over which the rolling average is calculated.

Chapters
00:00 Topic list
00:48 The Basic Setup
02:33 Calculating a Basic Rolling Average
05:54 Checking the Basic Arithmetic
08:26 Checking the Date Range
10:24 Averaging a Yearly Sum
13:27 Using a Quarterly Granularity
17:01 Adjusting the Date Range
19:11 Using a Monthly Granularity
24:02 A More Elegant Approach
29:08 Changing the Granularity
30:24 Changing the Date Range
31:26 Dealing with Blanks
37:28 Correcting Other Measures
38:53 User Controlled Measures

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!