Скачать или смотреть Iferror DAX Query (English)

Through this video , we will learn DAX Query named Iferror .

The IFERROR function in DAX (Data Analysis Expressions) is used to handle errors in your calculations. It evaluates an expression and returns a specified value if the expression results in an error; otherwise, it returns the value of the expression itself.

Syntax
IFERROR(value, value_if_error)
value: The expression you want to evaluate.
value_if_error: The value to return if the expression results in an error.
How to Use IFERROR
You can use the IFERROR function to trap and handle errors in your DAX expressions. This is particularly useful when you have calculations that might result in errors, such as division by zero or invalid data types.

Example
Suppose you have a dataset with Sales Amount and Quantities Sold, and you want to calculate the Unit Price. If Quantities Sold is zero, it would result in a division by zero error. You can use IFERROR to handle this:

Unit Price = IFERROR([Sales Amount] / [Quantities Sold], 0)