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.
431