Scribd
Upload
86 views

DAX Functions For Data Analysis

This document provides an overview of 16 commonly used DAX functions for data analysis, aggregation, filtering, and manipulation. The functions include SUMX, AVERAGEX, COUNTX, MINX, MAXX, CALCULATE, FILTER, RELATED, COUNTROWS, CONCATENATEX, RANKX, SUMMARIZE, DISTINCT, TODAY, YEAR, and IF.

Uploaded by

Heidi Cabrera Mancheno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
86 views

DAX Functions For Data Analysis

This document provides an overview of 16 commonly used DAX functions for data analysis, aggregation, filtering, and manipulation. The functions include SUMX, AVERAGEX, COUNTX, MINX, MAXX, CALCULATE, FILTER, RELATED, COUNTROWS, CONCATENATEX, RANKX, SUMMARIZE, DISTINCT, TODAY, YEAR, and IF.

Uploaded by

Heidi Cabrera Mancheno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

01

DAX Functions
For Data Analysis
Empower Your Insights with Power BI

Start
02

Aggregate functions

1. SUMX
This particular function calculates the sum of an
expression evaluated for each row in a table.

SUMX(table, expression)

2. AVERAGEX
This function returns the average of an expression
evaluated for each row in a table.

AVERAGEX(table, expression)

https://www.linkedin.com/in/azdine-bahloul/
03

3. COUNTX
This function counts the number of rows for which the
expression is not blank.

COUNTX(table, expression)

4. MINX ()
This function returns the minimum value of an
expression evaluated for each row in a table.

MINX(table, expression)

https://www.linkedin.com/in/azdine-bahloul/
04

5. MAXX ()
This function returns the maximum value of an
expression evaluated for each row in a table.

MAXX(table, expression)

Filter & Manipulate Functions

6. CALCULATE ()
This function modifies the filter context in a calculation
by specifying new filter conditions.

CALCULATE(expression, filter1, filter2, ...)

https://www.linkedin.com/in/azdine-bahloul/
05

7. FILTER()
This function returns a table that represents a subset of
another table or expression.

FILTER(table,condition)

8. RELATED ()
This function returns a single value from another table in
the relationship.

RELATED(related_table[column_name])

https://www.linkedin.com/in/azdine-bahloul/
06

9. COUNTROWS ()
This function counts the number of rows in a table or
expression.

COUNTROWS(table)

10. CONCATENATEX ()
This function concatenates the result of an expression
evaluated for each row in a table, using a specified
delimiter.

CONCATENATEX(table, expression, delimiter)

https://www.linkedin.com/in/azdine-bahloul/
07

Other Useful Functions

11. RANKX ()
This function returns the rank of a value in a column, as
determined by a specified expression.

RANKX(table, expression, [order], [ties])

12. SUMMARIZE ()
This function creates a summary table over a set of
groups or columns.

SUMMARIZE(table, group_by_column1,
group_by_column2, ..., expression)

https://www.linkedin.com/in/azdine-bahloul/
08

13. DISTINCT ()
This function returns a table with unique rows from a
specified table or expression.

DISTINCT(table)

14. TODAY ()
This function returns the current date.

TODAY()

https://www.linkedin.com/in/azdine-bahloul/
09

15. YEAR()
This function returns the year component of a date.

YEAR(date)

16. IF ()
This function returns one value if a condition is true and
another value if it's false.

IF(condition, value_if_true, value_if_false)

https://www.linkedin.com/in/azdine-bahloul/

You might also like