In this video Mitchell takes a look at some of the challenges that exist when working with averages and then how you can use a combination of DAX functions to work around those challenges. With Summarize and AverageX you can easilY create the averages you want.

We also take a look at modifying the filter context to include the last 3 months of data with the CALCULATE function and DATESINPERIOD! Enjoy the video!

If you want to explore formal DAX training including live bootcamps and recorded class content, please check out https://pragmaticworks.com

#MitchellPearson #MitchellSQL #PragmaticWorks