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

     

     

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Anonymous  When there is no value or maybe we can say if the value "1005" or "1006" is noticed then I would like to call it "New Test". Thanks