Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Solved! Go to 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")
Thanks you very much! This is good way to solve it!😀
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |