Scribd
Upload
28 views4 pages

Dax List

This document provides a categorized cheat list of useful DAX formulas, including aggregation, filter, logical, time intelligence, text, mathematical, statistical, parent-child, relationship management, information, context management, date, and advanced functions. Each category contains specific functions with brief descriptions of their purposes. This serves as a quick reference for users working with DAX in data analysis.

Uploaded by

Nagaraj M
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
28 views4 pages

Dax List

This document provides a categorized cheat list of useful DAX formulas, including aggregation, filter, logical, time intelligence, text, mathematical, statistical, parent-child, relationship management, information, context management, date, and advanced functions. Each category contains specific functions with brief descriptions of their purposes. This serves as a quick reference for users working with DAX in data analysis.

Uploaded by

Nagaraj M
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/ 4

Here's a quick cheat list of useful DAX formulas categorized by function type:

### Aggregation Functions

- `SUM` - Adds up all values in a column.

- `AVERAGE` - Calculates the average of a column.

- `MIN` / `MAX` - Finds the minimum or maximum value.

- `COUNT` / `COUNTROWS` - Counts values or rows.

### Filter Functions

- `CALCULATE` - Evaluates an expression in a modified filter context.

- `FILTER` - Returns a table that has been filtered.

- `ALL` / `ALLSELECTED` - Removes filters or returns context-aware values.

### Logical Functions

- `IF` - Performs conditional logic.

- `AND` / `OR` - Combines multiple logical conditions.

- `NOT` - Reverses a logical value.

### Time Intelligence Functions

- `DATEADD` - Shifts dates by a specified interval.

- `TOTALYTD` / `TOTALMTD` - Calculates totals for year-to-date or month-to-date.

- `PREVIOUSMONTH` / `NEXTQUARTER` - Returns values for specific time ranges.

### Text Functions

1
- `CONCATENATE` - Combines two strings into one.

- `LEFT` / `RIGHT` - Returns specified characters from a string.

- `SEARCH` - Finds the starting position of a substring.

### Mathematical Functions

- `ROUND` / `ROUNDUP` / `ROUNDDOWN` - Rounds numbers to specified decimals.

- `DIVIDE` - Safely divides two numbers, handling division by zero.

- `POWER` - Raises a number to the power of another.

Statistical Functions

MEDIAN - Returns the median value.

PERCENTILE.INC / PERCENTILE.EXC - Returns the inclusive or exclusive percentile.

RANKX - Ranks values in a table based on an expression.

Parent-Child Functions

PATH - Returns the path from a parent to a child.

PATHITEM - Retrieves a specific item in a path string.

PATHLENGTH - Returns the number of levels in a path.

Relationship Management

2
RELATED - Returns a value from a related table.

RELATEDTABLE - Returns a table related to the current row.

USERELATIONSHIP - Activates an inactive relationship.

Information Functions

ISBLANK - Checks if a value is blank.

ISNUMBER / ISTEXT - Checks if a value is a number or text.

LOOKUPVALUE - Retrieves values based on a specific condition.

Context Management Functions

EARLIER - Refers to an earlier row context.

VALUES - Returns distinct values in a column.

SELECTEDVALUE - Returns the selected value if there's only one in the column.

Date Functions

YEAR / MONTH / DAY - Extracts the year, month, or day from a date.

NOW / TODAY - Returns the current date and time or just the date.

3
EDATE - Shifts a date by a specified number of months.

Advanced Functions

GENERATE - Combines two tables by calculating the Cartesian product.

CROSSJOIN - Returns the Cartesian product of two tables.

UNION - Combines rows from two tables.

INTERSECT - Returns common rows from two tables

You might also like