Forum Discussion

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
6 years ago
Solved

lookupvalue - To replace (Blank) with N/A

Hello everyone,    I've created a coulmn in dax using  Column = LOOKUPVALUE('Table1'[Curr Code],'Table1'[Curr Code],Table2[Correct Curr])   However, it returning some rows with (Blank) which ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    ritanoori - Perhaps:

     

    Column =
  VAR __Value = LOOKUPVALUE('Table1'[Curr Code],'Table1'[Curr Code],Table2[Correct Curr])
RETURN
  IF(ISBLANK(__Value),"N/A",__Value)

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

ritanoori - Perhaps:

 

Column =
  VAR __Value = LOOKUPVALUE('Table1'[Curr Code],'Table1'[Curr Code],Table2[Correct Curr])
RETURN
  IF(ISBLANK(__Value),"N/A",__Value)

 

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
6 years ago

Thanks! 🙂