IFERROR CAN'T RETURN NULL as Text

[Leo_5117]

Dear all

I use IFERROR to get sheet1 value from foglio1, but there are some data can't be queried.

So I use this 

Chinese Description = IFERROR(LOOKUPVALUE(foglio1[Chinese Description],foglio1[物料],Sheet1[物料]),"null")

But Power BI just return blank without "null" as follow you see:

And it missing blank line within PowerBI report like this:

Please help me to slove it,thank you very much!!!

[Leo_5117]

Thanks you very much! This is good way to solve it!😀

[Hoangechip910 · Accepted solution]

Hi

LOOKUPVALUE function have parameter of AlternateResult when result return to error, not need to use IFERROR

Chinese Description = LOOKUPVALUE(foglio1[Chinese Description],foglio1[物料],Sheet1[物料],"null")