By Andrew Gould

Get files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-aggregate-functions/

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!

This video explains how to use DAX aggregate functions such as Sum, Average, Min and Max to aggregate a single column. You'll also learn how to use SumX, AverageX, MinX and MaxX to aggregate the results of expressions.

Chapters
00:00 Topic list
00:39 Importing Data
02:14 Basic Aggregate Functions with Measures
05:44 Aggregates without Measures
07:39 Summing the Result of a Calculation
09:05 Creating a Calculated Column
10:37 Using the SumX Function
12:28 The AverageX Function
13:31 Nesting Functions in AggregateX Functions
15:52 Referring to Columns in Other Tables

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!