As with any programming language, coding DAX calculations will inevitably result in an error being generated. While error handling in DAX is perhaps not quite as mature and robust as some other programming languages, DAX does provide some basic capabilities for handling errors within DAX code. A certain, limited number of DAX functions include internal error checking, and this recipe demonstrates using the built-in error checking provided by these special DAX functions.
To prepare for this recipe, perform the following steps:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R02_Table with the following data: