Scribd
Upload
23 views1 page

Types of DAX Functions

Details About DAX Functions

Uploaded by

Safwan Ahsan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
23 views1 page

Types of DAX Functions

Details About DAX Functions

Uploaded by

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

Types of DAX Functions

Understanding the different types of DAX functions and their use cases is essential for
effective data analysis and modeling in Power BI and other DAX-supported tools. Here's a
quick reference of the function categories:

1. Aggregation Functions: SUM, AVERAGE, COUNT, MAX, MIN


2. Filter Functions: CALCULATE, FILTER, ALL, REMOVEFILTERS
3. Logical Functions: IF, AND, OR
4. Time Intelligence Functions: SAMEPERIODLASTYEAR, PREVIOUSMONTH, DATESYTD,
DTAESMTD, DATESQTD, EDATE
5. Date/Time Functions: NOW, YEAR, MONTH
6. Mathematical Functions: DIVIDE, ROUND, ABS, SIGN, LOG
7. Statistical Functions: STDEV.P, RANKX, MEDIAN
8. Text Functions: CONCATENATE, LEFT, RIGHT, LEN
9. Information Functions: ISBLANK, ISNUMBER, ISTEXT
10. Table Manipulation Functions: ADDCOLUMNS, SUMMARIZE, CROSSJOIN
11. Relationship Functions: RELATED, RELATEDTABLE
12. Iterative Functions: SUMX, AVERAGEX

Back to Contents

You might also like