Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Update existing column value based on custom column

I have table A with the column City.  I have a custom column in this table which basically does search in table B city column and if it finds it put 'Found" in that column.  I would like to update th...
Need Help
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi stribor45 ,

     

    you can capitalize or proper both columns, before FindTex comparison. 

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

tackytechtom is there a way that this can be done in DAX since I am a little more familiar with it and would also like to add some other pieces to this small code adjustment

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi stribor45 ,

     

    Try to plot a table visual with Call ID column, City Column, Custom Column and a measure like:
     
    Status = 
    IF(
        MAX(TableA[Custom]) = "Found",
        "Found!!!", "NA"
    )

    • stribor45's avatar
      stribor45
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      but custom columns have to be generated first. where does your formula look into Table B to find a matching value in a column of Table  formula has to go through each row of Table A and look if there is a city in the current row that matches the city column in table B and if found put the word "match" in the custom column

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper User
        2 years ago

        hi stribor45 ,

         

        not sure if i fully get you, try to plot a table visual with call id colum, city column and a measure like:

        Status = 
IF(
    MAX(TableA[City]) IN VALUES(TableB[City]),
    "Found!!!", "NA"
)

         

        it worked like: