A common requirement in authoring DAX code is to provide a default value for the result of a calculation that might otherwise be blank. The classic approach to solving this requirement is by using an IF statement. For example, the following code returns the value of either the Sales[Net Price] column or the Sales[Unit Price] column, whichever is first to not be blank: