Search

Search Scripts

Scripting Reference Guides

Rick W

DAX Information Functions

Information Functions within Microsoft Power BI.

A. ISBLANK

IsEmpty = ISBLANK(Sales[Quantity]) 

This example checks if the Quantity column in the Sales table is blank or empty. If the value is blank, it returns TRUE; otherwise, it returns FALSE. 

B. ISERROR

HasError = ISERROR(Divide(1, 0)) 

This example checks if the result of the Divide function, dividing 1 by 0, is an error. If an error occurs, it returns TRUE; otherwise, it returns FALSE. 

C. ISTEXT:  

IsTextValue = ISTEXT(Orders[CustomerName]) 

This example checks if the value in the CustomerName column of the Orders table is text. If the value is text, it returns TRUE; otherwise, it returns FALSE. 

D. ISNUMBER

IsNumeric = ISNUMBER(Sales[Amount]) 

This example checks if the values in the Amount column of the Sales table are numbers. If the value is a number, it returns TRUE; otherwise, it returns FALSE. 

Previous Article DAX Mathematical Functions
Next Article DAX Advanced Functions
Print
430