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 category

FunctionDescription
CONTAINSReturns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
CUSTOMDATAReturns the content of the CustomData property in the connection string.
ISBLANKChecks whether a value is blank, and returns TRUE or FALSE.
ISERRORChecks whether a value is an error, and returns TRUE or FALSE.
ISEVENReturns TRUE if number is even, or FALSE if number is odd.
ISINSCOPEReturns true when the specified column is the level in a hierarchy of levels.
ISLOGICALChecks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.
ISNONTEXTChecks if a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBERChecks whether a value is a number, and returns TRUE or FALSE.
ISONORAFTERA boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters.
ISTEXTChecks if a value is text, and returns TRUE or FALSE.
LOOKUPVALUEReturns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
USERNAMEReturns the domain name and username from the credentials given to the system at connection time.

***** Related Blog Posts *****
60 Page DAX Formula Reference Guide Download Now Available
Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX
ALL Function in Power BI – How To Use It With DAX
Normalizing Results On Different Days In Power BI Using DAX

***** Related Course Modules *****
Ultimate Beginners Guide to DAX
Mastering DAX Calculations
Solving Analytical Scenarios w/ Power BI and DAX
DAX Formula Deep Dives
Advanced DAX Combinations

***** Related Video Tutorials *****
Ultimate Beginners Guide to DAX

What Is DAX? & Why Do You Need To Learn It – (1.2) Ultimate Beginner Guide to DAX
Formula Syntax, Comments & Variables – (1.6) Ultimate Beginners Guide to DAX
Examples Of Advanced DAX – (1.18) Ultimate Beginners Guide to DAX

***** Related Support Forum Posts*****
Mastering DAX Calculations: What Is DAX?
Understanding DAX Formula
Developing Complex Dax functions
Calculating dept head performance based on direct report performance

Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership