DAX Functions Cheat
Sheet Overview
questions 2025-
2026(updated &
already graded A+)
what does an aggregation functions do?
summarizes a set of values into a single result
list 6 aggregation functions
SUM, AVERAGE, MAX, MIN, COUNT, DIVIDE
what does an iterator functions do?
applies a calculation or expression to each row in a table
list five iterator functions
SUMX, AVERAGEX, MAXX, MINX, COUNTX
what does a date & time function do?
creates calculations based on dates and time
list 8 date & time functions
CALENDAR, DATE, DATEDIFF, DATEVALUE, EOMONTH,
NETWORKDAYS, WEEKDAY, WEEKNUM
what does a logical function do?
performs logical operations
Sheet Overview
questions 2025-
2026(updated &
already graded A+)
what does an aggregation functions do?
summarizes a set of values into a single result
list 6 aggregation functions
SUM, AVERAGE, MAX, MIN, COUNT, DIVIDE
what does an iterator functions do?
applies a calculation or expression to each row in a table
list five iterator functions
SUMX, AVERAGEX, MAXX, MINX, COUNTX
what does a date & time function do?
creates calculations based on dates and time
list 8 date & time functions
CALENDAR, DATE, DATEDIFF, DATEVALUE, EOMONTH,
NETWORKDAYS, WEEKDAY, WEEKNUM
what does a logical function do?
performs logical operations
