Forum Discussion
Update existing column value based on custom column
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
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:
Ahh. I see what you mean now. Thank you. This works fine but when I was posting this I posted a very simplified example so it is easier to communicate. What I am trying to do is a little bit more complex as I have to match other values. Table A and B also have State and ZIP codes as well so those need to match as well. Sorry, it was my error since I simplified the example for better understanding. My apologies.
As an example for each row in Table A I have to find if there is a matching row in Table B that has the same column values
Is there a way to modify this so it ignores the case when comparing? It works for me when I compare "Atlanta" to "Atlanta" but it doesn't when it is "Atlanta" to "AtlanTA".
Table2WithSubstring = Table.AddColumn(#"Table A", "CitySubstringMatch", each not List.IsEmpty(List.FindText(#"Table B"[City], [City Name])))