5 DAX Functions Flashcards
What is the primary difference between DAX and Excel functions?
DAX functions work with tables and columns, not individual cells.
Where do DAX functions operate?
On the data within your Power BI data model, which can include multiple tables with relationships.
What is crucial for writing DAX expressions?
Correct syntax.
What features does the DAX editor in Power BI Desktop offer?
IntelliSense, syntax highlighting, and formula validation.
What does the function ISBLANK do?
Checks if a value is blank.
What does the function ISERROR do?
Checks if an expression results in an error.
How do iterator functions work in DAX?
By iterating over each row in a table and performing a calculation on that row.
Name three examples of iterator functions.
- RANKX
- FILTER
- COUNTROWS
What does the YEAR function do?
Extracts the year from a date.
What does the MONTH function do?
Extracts the month from a date.
What does the DAY function do?
Extracts the day from a date.
What does the NOW function return?
The current date and time.
What does the EOMONTH function return?
The last day of the month.
What does the FIND function do?
Finds the position of a text string within another text string.
What does the REPLACE function do?
Replaces part of a text string with another text string.
What does the TRIM function do?
Removes leading and trailing spaces from a text string.
What does the UPPER function do?
Converts all characters in a text string to uppercase.
What does the AVERAGE function calculate?
The average of a set of values.
What does the COUNT function do?
Counts the number of rows in a table or non-blank values in a column.
What does the DISTINCTCOUNT function do?
Counts the number of distinct values in a column.
What does the ROUND function do?
Rounds a number to a specified number of digits.
What does the TRUNC function do?
Truncates a number to an integer.
What does the INT function return?
The integer portion of a number.
What do information functions provide information about?
Values, columns, or tables.
Give an example of an information function.
- ISNUMBER
- ISTEXT
- HASONEVALUE
What do filter functions do?
Filter tables and return a subset of data.
Name three examples of filter functions.
- FILTER
- ALL
- ALLEXCEPT
What do table manipulation functions work with?
Entire tables.
Name three examples of table manipulation functions.
- UNION
- INTERSECT
- EXCEPT
