Forum Discussion
stribor45
Post Prodigy
Post ProdigyUpdate 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...
FreemanZ
Super User
Super Userhi 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:
stribor45Post Prodigy
Post ProdigyIs 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])))