Forum Discussion

lavdeep's avatar
lavdeep
Advocate I
7 years ago
Solved

How to print error ??

Hi,

 

I want print error in a column as we have formula in Excel  =NA() how to do same in dax

  • Couple of options. If you want to display some custom error message, you can try to replace Errors with the message (works for text type fields).

     

     

    Or use error handling on the column that has errors. Here's how:

    Add custom column to your data, use try (all lowercase) and pass it the column name that has errors. Expand this custom column to get the Error. And then expand the Error column further to get the reason and details.

     

     

    Hope this helps.

     

    Thanks,

    Tarun

1 Reply

  • Couple of options. If you want to display some custom error message, you can try to replace Errors with the message (works for text type fields).

     

     

    Or use error handling on the column that has errors. Here's how:

    Add custom column to your data, use try (all lowercase) and pass it the column name that has errors. Expand this custom column to get the Error. And then expand the Error column further to get the reason and details.

     

     

    Hope this helps.

     

    Thanks,

    Tarun