fbpx
Skip to content

DAX Aggregation Functions in Power BI

    Last Updated on: 3rd July 2024, 10:41 am

    DAX Aggregation Functions in Power BI

    Data Analysis Expressions (DAX) is a formula language used in Microsoft Power BI, Power Pivot for Excel, and SQL Server Analysis Services Tabular models. Aggregation functions in DAX are essential tools for summarizing data, performing calculations across multiple rows, and deriving meaningful insights from large datasets. .

    1.1 Basic COUNT Function

    Syntax

    COUNT()

    2. SUM Function

    The SUM function calculates the sum of all values in a specified column.

    2.1 Basic SUM Function

    Syntax

    SUM()

    3. AVERAGE Function

    The AVERAGE function calculates the arithmetic mean of all values in a specified column.

    3.1 Basic AVERAGE Function

    Syntax

    AVERAGE()

    4. MIN Function

    The MIN function returns the smallest value in a specified column.

    4.1 Basic MIN Function

    Syntax

    MIN()

    5. MAX Function

    The MAX function returns the largest value in a specified column.

    5.1 Basic MAX Function

    Syntax

    MAX()

    Share this post on social!

    Comment on Post

    Your email address will not be published. Required fields are marked *