Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 advise since I tried using ISBLANK but nothing seems to work

 
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

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

     

     

17 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Try IF( ISBANK( ......) = True, "Value you want when blank", "value you want when not blank i.e. your function")

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Anonymous Thanks but no change. For some reason the blank values remain

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      V-V Anonymous Please refer to the attached!

       

      Can the category for both these entries be changes to "New Test"?

       

      Dokumente

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

         

        Can you elaborate on the circumstances under which the value of the “Category New” column changes to “New Test”?

         

         

         

        Best Regards,

        Jayleny