Excel DAX - Special Values
Advertisements
The following table lists some DAX special values.
Sr.No | Special Value & Description |
---|---|
1 | BLANK A null, or a blank value, or an empty cell, or a missing value. |
2 | Infinity Infinity value, as considered in mathematics (∞). DAX returns Infinity, if there is a division by zero. |
3 | NaN Not a Number. DAX returns NaN for 0/0 and Infinity/Infinity. |
If you divide an expression by Infinity, you will not get an error, as DAX returns 0.
excel_dax_syntax.htm
Advertisements