Channel: WiseOwlTutorials

Category: Education

Tags: averageexpressionfree tutorialmaxaveragexmaxxonline trainingpower bipower bi desktopsumfree traininglowestonline tutorialaggregatecalculated columntotalminmeasurehighestminxdaxtutorialsumxwise owl

Description: By Andrew Gould Get files here 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 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!