If error showing blank instead of value I want in If Error

[Anonymous]

Hi everyone,

My If functions are working fine, however when I add IF Error to them eg If Error (value), "yyYearError", this comes up as blank instead of filling the cell with "yyYearError". I have the same data in Excel and the IF error function there fills in said cells with "yyYearError", however with dax these values that should have the IFError value are instead just blank?

Thank you in advance,

Regards,

P

[MFelix]

Hi @Anonymous,

Be aware that the way formulas work in DAX are different from the ones in excel.

What type of values are you calculating, a measure or a column? Can you share the syntax of your formula?

Your measure can returna blank and not an error in DAX so when you apply the iferror since there is no error it will return blanks because it's the result of the measure.

Regards,

MFelix

[Anonymous]

Hi MFelix,

Thanks for your reply,

It's a calculated column and the syntax is:
IFERROR( IF(column A) = "Yes", "na",
IF(column B) =Blank(), "No Record",
Lookupvalue(lookupgroupZ, lookupgroupcodeZ,ColumnB),"CodeError")

Thanks

[v-piga-msft · Accepted solution]

Hi @Anonymous,

I also agree with MFelix.

By my tests with IFERROR in Power BI, if the value of IFERROR is blank, it will return blank, if the value is error, it will return the error value you set.

You could refer to the image below.

So you'd better check if your fomula below returns blank value.

IF(column A) = "Yes", "na",
IF(column B) =Blank(), "No Record",
Lookupvalue(lookupgroupZ, lookupgroupcodeZ,ColumnB)

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best  Regards,

Cherry

[MFelix]

Hi @Anonymous,

Are you sure about the syntax? This doesn't appear DAX.

But based on your calculation since you are creating a column this will not give you an error since the values form columns if they don't exists will return a blank.

If you were calculating a division for example that would give you and error, on this syntax you will get text.

Regards,

MFelix