Forum Discussion
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 ...
ritanoori - Perhaps:
Column = VAR __Value = LOOKUPVALUE('Table1'[Curr Code],'Table1'[Curr Code],Table2[Correct Curr]) RETURN IF(ISBLANK(__Value),"N/A",__Value)
ritanoori - Perhaps:
Column =
VAR __Value = LOOKUPVALUE('Table1'[Curr Code],'Table1'[Curr Code],Table2[Correct Curr])
RETURN
IF(ISBLANK(__Value),"N/A",__Value)
Thanks! 🙂
