cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Leo_5117
Regular Visitor

IFERROR CAN'T RETURN NULL as Text

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:

001.PNG

 

And it missing blank line within PowerBI report like this:

002.PNG

 

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

 

1 ACCEPTED SOLUTION
Hoangechip910
Frequent Visitor

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

View solution in original post

2 REPLIES 2
Leo_5117
Regular Visitor

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

Hoangechip910
Frequent Visitor

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.