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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

       

      Please try the following Dax:

      Measure = IF(SELECTEDVALUE('Actuals'[Category])=BLANK(),"New Test",MAX('Actuals'[Category]))

       

       

       

       

       

      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

        Anonymous Thank you I see it is close but please refer to the below. The first 3 rows under measure column should show up as "BC"