Cheat Sheet: DAX

// Returns the sum of all values in a column.
SUM(column_name)

// Returns the average of values in a column.
AVERAGE(column_name)

// Returns the number of non-empty values in a column.
COUNT(column_name)

// Returns the maximum value in a column.
MAX(column_name)

// Returns the minimum value in a column.
MIN(column_name)

// Safely divides two numbers, returns alternate result if denominator is 0.
DIVIDE(numerator, denominator, alternate_result)

// Calculates the sum of an expression evaluated for each row in a table.
SUMX(table, expression)

// Calculates the average of an expression evaluated for each row in a table.
AVERAGEX(table, expression)

// Returns the maximum value of an expression evaluated for each row in a table.
MAXX(table, expression)

// Returns the minimum value of an expression evaluated for each row in a table.
MINX(table, expression)

// Returns the count of non-blank results from evaluating an expression for each row.
COUNTX(table, expression)

// Returns one value if the condition is true, otherwise returns another value.
IF(condition, true_result, false_result)

// Evaluates an expression and returns different results based on matching values.
SWITCH(expression, value1, result1, value2, result2, ...)

// Returns TRUE if both conditions are true.
AND(condition1, condition2)

// Returns TRUE if either condition is true.
OR(condition1, condition2)

// Reverses the result of a logical condition (TRUE becomes FALSE, and vice versa).
NOT(logic)

// Returns the value if there is no error; otherwise returns the specified alternate value.
IFERROR(value, value_if_error)

// Shifts dates by the specified number of intervals (e.g., days, months).
DATEADD(dates, number_of_intervals, interval)

// Returns dates between two given dates.
DATESBETWEEN(dates, date1, date2)

// Calculates the year-to-date total for a given measure.
TOTALYTD(SUM(column), date_column)

// Returns the dates from the beginning of the year to the current date.
DATESYTD(date_column)

// Returns the set of dates in the same period of the previous year.
SAMEPERIODLASTYEAR(date_column)

// Returns the current date.
TODAY()

// Returns the current date and time.
NOW()

// Returns the year from a date.
YEAR(date)

// Returns the month from a date.
MONTH(date)

// Returns the day of the month from a date.
DAY(date)

// Returns a table with a single column of dates between start_date and end_date.
CALENDAR(start_date, end_date)

// Creates a date value from the specified year, month, and day.
DATE(year, month, day)

// Returns the difference between two dates in the specified interval (e.g., days, months).
DATEDIFF(date1, date2, interval)

// Returns the day of the week for a date.
WEEKDAY(date, return_type)

// Returns the week number for a date.
WEEKNUM(date, return_type)

// Rounds a number to the specified number of digits.
ROUND(number, num_digits)

// Safely divides two numbers, returns alternate result if division by zero occurs.
DIVIDE(numerator, denominator, alternateResult)

// Returns the remainder after dividing a number by a divisor.
MOD(number, divisor)

// Returns the rank of a value in a table based on an expression.
RANKX(table, expression, value, [order], [ties])

// Returns the kth percentile excluding the value k.
PERCENTILE.EXC(column, k)

// Returns the kth percentile including the value k.
PERCENTILE.INC(column, k)

// Returns a table filtered by a condition.
FILTER(table, condition)

// Changes the context of the calculation by applying filters.
CALCULATE(expression, filter1, filter2, ...)

// Ignores all filters applied to a table or column.
ALL(table)

// Returns all rows, excluding any blank rows.
ALLNOBLANKROW(table, column_name1, column_name2, ...)

// Ignores all filters except for the specified columns.
ALLEXCEPT(table, column1, column2, ...)

// Removes all filters from the specified table or columns.
REMOVEFILTERS(table, column_name1, column_name2, ...)

// Joins two text strings into one.
CONCATENATE(text1, text2)

// Returns the starting position of a substring within a text string.
FIND(find_text, within_text, start_num, not_found_value)

// Formats a value according to the specified format string.
FORMAT(value, format)

// Returns the length of a text string.
LEN(text)

// Converts a text string to lowercase.
LOWER(text)

// Converts a text string to uppercase.
UPPER(text)

// Removes extra spaces from text.
TRIM(text)

// Returns the leftmost characters from a text string.
LEFT(text, num_chars)

// Returns the rightmost characters from a text string.
RIGHT(text, num_chars)

// Searches for a substring within a text string.
SEARCH(find_text, within_text, start_num, not_found_value)

// Replaces occurrences of old_text with new_text.
SUBSTITUTE(text, old_text, new_text, instance_num)

// Replaces part of a text string, based on position and length.
REPLACE(old_text, start_position, num_chars, new_text)

// Groups a table by specified columns and returns aggregated results.
SUMMARIZE(table, groupby_column1, "name1", expression1, ...)

// Returns a table that contains unique values from a column or set of columns.
DISTINCT(table)

// Adds calculated columns to a table.
ADDCOLUMNS(table, "new_column_name", expression)

// Returns a table with selected columns.
SELECTCOLUMNS(table, name1, expression1, name2, expression2)

// Returns the Cartesian product of two tables.
CROSSJOIN(table1, table2)

// Groups a table by specified columns and applies expressions to each group.
GROUPBY(table, groupby_column_name, column_name, expression)

// Returns a table that contains the common rows from two tables.
INTERSECT(left_table, right_table)

// Returns the natural inner join of two tables.
NATURALINNERJOIN(left_table, right_table)

// Returns the natural left outer join of two tables.
NATURALLEFTOUTERJOIN(left_table, right_table)

// Returns the rows from the first table that are not in the second table.
EXCEPT(left_table, right_table)

// Returns the union of two tables (rows from both tables).
UNION(table1, table2)