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 I want to replace with "N/A" what should I do? 
 
Thanks
Rita

 

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)

     

2 Replies

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