cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lavdeep Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
tarunsingla Member
Member

Re: How to print error ??

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).

 

Untitled.png

 

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.

 

Untitled1.png

 

Hope this helps.

 

Thanks,

Tarun

1 REPLY 1
tarunsingla Member
Member

Re: How to print error ??

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).

 

Untitled.png

 

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.

 

Untitled1.png

 

Hope this helps.

 

Thanks,

Tarun