Forum Discussion
J18IB
3 years agoNew Member
LookupValue if error help
Fairly new to Power Bi so looking for some help. Below is the formula in columns I am using: =iferror(Lookupvalue(), "No Found") However, it is returning blanks. When looking in the other sh...
HotChilli
3 years agoCommunity Champion
Are you telling us that you are using LOOKUPVALUE without passing any parameters? That won't work.
https://dax.guide/lookupvalue/
-
Once you get the correct values to pass using LOOKUPVALUE, you can add the "No found" as the last parameter and it will be used as an alternative/default value