Forum Discussion
Replace (Blank) with 'Value' - Calculated Column
Hi Team, I have a calculated column in my table view as below : Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank()) which returns the below Please...
Hi Anonymous Thanks. Tried same for some reason my side it does not work. Also please note that my actual calculation is a Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank())
Try IF( ISBANK( ......) = True, "Value you want when blank", "value you want when not blank i.e. your function")
Anonymous Thanks but no change. For some reason the blank values remain
I think the issue is within the lookup, but I'm not experienced enough to resolve it without seeing more data. Hopefully someone will come along and give you more guidance