Podcast
Questions and Answers
The CONTAINS function returns a statistics table for each column in each table in the model
The CONTAINS function returns a statistics table for each column in each table in the model
False (B)
The ISNUMBER function determines if a value is blank
The ISNUMBER function determines if a value is blank
False (B)
The HASONEFILTER function returns true if there are exactly one directly filtered values on ColumnName
The HASONEFILTER function returns true if there are exactly one directly filtered values on ColumnName
True (A)
The ISEMPTY function verifies whether a column is empty
The ISEMPTY function verifies whether a column is empty
The CONTAINSSTRING function is case-sensitive
The CONTAINSSTRING function is case-sensitive
The ISERROR function returns true if the value is logical
The ISERROR function returns true if the value is logical
The ISNONTEXT function returns true if a value is blank
The ISNONTEXT function returns true if a value is blank
The ISINSCOPE function returns true when a column is being filtered
The ISINSCOPE function returns true when a column is being filtered
The CUSTOMDATA function returns the information found in the connection string’s CustomData property
The CUSTOMDATA function returns the information found in the connection string’s CustomData property
The ISCROSSFILTERED function returns true when a column is being directly filtered
The ISCROSSFILTERED function returns true when a column is being directly filtered
The ISFILTERED function returns true when a table is empty
The ISFILTERED function returns true when a table is empty
The ISSUBTOTAL function creates a new column in a SUMMARIZE expression that returns True if the row has values for the subtotal column specified as an argument
The ISSUBTOTAL function creates a new column in a SUMMARIZE expression that returns True if the row has values for the subtotal column specified as an argument
DAX functions can only take in a single argument.
DAX functions can only take in a single argument.
The ISERROR function returns FALSE if the referenced value contains an error.
The ISERROR function returns FALSE if the referenced value contains an error.
DAX information functions examine the entire dataset to determine compatibility with the expected type.
DAX information functions examine the entire dataset to determine compatibility with the expected type.
The Contains function returns TRUE if the values for any of the referred columns exist.
The Contains function returns TRUE if the values for any of the referred columns exist.
DAX formulas can only be used with numerical data.
DAX formulas can only be used with numerical data.
DAX functions are limited to mathematical and trigonometric operations.
DAX functions are limited to mathematical and trigonometric operations.
The DAX function DATEVALUE returns the number of boundaries between two dates.
The DAX function DATEVALUE returns the number of boundaries between two dates.
The DAX function DATEDIFF can use 'Second' as a valid Interval value.
The DAX function DATEDIFF can use 'Second' as a valid Interval value.
The DAY function in DAX can accept dates in any string format.
The DAY function in DAX can accept dates in any string format.
The DAX function NOW returns the current date and time as a string value.
The DAX function NOW returns the current date and time as a string value.
In DAX, the DAY function can accept an expression that yields a date as an argument.
In DAX, the DAY function can accept an expression that yields a date as an argument.
DATEDIFF can calculate the difference between dates at a minute level precision.
DATEDIFF can calculate the difference between dates at a minute level precision.
The DAX Calendar function can generate a table with multiple columns.
The DAX Calendar function can generate a table with multiple columns.
The DATE function in DAX requires four parameters to create a date.
The DATE function in DAX requires four parameters to create a date.
The DATEVALUE function in DAX ignores the client computer's locale and date/time settings during conversion.
The DATEVALUE function in DAX ignores the client computer's locale and date/time settings during conversion.
The CALENDAR function in DAX can generate a table with a non-continuous range of dates.
The CALENDAR function in DAX can generate a table with a non-continuous range of dates.
The DAX Date function returns a date in a format that can be used as a text string.
The DAX Date function returns a date in a format that can be used as a text string.
The DATEVALUE function in DAX can only convert dates in a specific format.
The DATEVALUE function in DAX can only convert dates in a specific format.
Study Notes
DAX Functions Overview
- CONTAINS Function: Produces a statistics table for each column across all tables in the data model.
- ISNUMBER Function: Checks if a value is blank within the context of numbers.
- HASONEFILTER Function: Returns true when a specific column has exactly one filtered value.
- ISEMPTY Function: Confirms whether a column is entirely empty.
- CONTAINSSTRING Function: Performs a case-sensitive check for occurrences of a substring within a string.
- ISERROR Function: Indicates if a value is logical and returns true for errors.
- ISNONTEXT Function: Verifies if a value is blank, similar in context to ISNUMBER.
- ISINSCOPE Function: Returns true when a column undergoes filtering.
- CUSTOMDATA Function: Retrieves information from a connection string’s CustomData property.
- ISCROSSFILTERED Function: Detects if a column has been directly filtered.
- ISFILTERED Function: Returns true when an entire table is empty.
- ISSUBTOTAL Function: Adds a column in a SUMMARIZE expression, indicating if the row possesses values in the specified subtotal column.
DAX Function Limitations
- DAX functions typically accept only a single argument.
- ISERROR Function: Outputs false if the referenced value does not result in an error.
- DAX information functions evaluate the dataset entirely for type compatibility.
- Basic logical checks, like CONTAINS, yield true if any referred column’s values exist.
DAX Date and Time Functions
- DAX is tailored primarily for numerical data operations; mathematical and trigonometric functions are commonly utilized.
- DATEVALUE Function: Converts dates while ignoring client locale settings; accepts specific date formats.
- DATEDIFF Function: Can calculate intervals down to the minute level and recognizes 'Second' as a valid interval value.
- DAY Function: Accepts date formats from strings and can take an expression yielding a date.
- NOW Function: Returns the current date and time formatted as a string.
- CALENDAR Function: Generates a date table even for non-continuous ranges.
- DATE Function: Requires four parameters to successfully generate a date.
Additional Insights
- DATEDIFF can compute differences between two dates with considerable precision.
- Overall, DAX functions provide extensive capabilities for data manipulation and analysis in BI environments.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of Excel functions with this quiz! Questions cover the usage and outputs of functions like CONTAINS, ContainsString, and ISBLANK.
