Information functions

DAX information functions look at the cell or row that is provided as an argument and tells you whether the value matches the expected type. For example, the ISERROR function returns TRUE if the value that you reference contains an error.

In this section

Function Description
CONTAINS Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
CUSTOMDATA Returns the content of the CustomData property in the connection string.
ISBLANK Checks whether a value is blank, and returns TRUE or FALSE.
ISERROR Checks whether a value is an error, and returns TRUE or FALSE.
ISEVEN Returns TRUE if number is even, or FALSE if number is odd.
ISINSCOPE Returns true when the specified column is the level in a hierarchy of levels.
ISLOGICAL Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.
ISNONTEXT Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBER Checks whether a value is a number, and returns TRUE or FALSE.
ISONORAFTER A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters.
ISTEXT Checks if a value is text, and returns TRUE or FALSE.
LOOKUPVALUE Returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
USERNAME Returns the domain name and username from the credentials given to the system at connection time.