Using the Concatenating Expression to join fields
I have a table called locations. It has three fields, City , State and Country.
In another table called Company Details, I have a field called location. I want to combine the City and State fields from the locations table to create the dropdown values for this field.
I used this expression CONCATENATE(Locations[City], Locations[State]) in the ValidIf but it generated an invalid data constraint error.
What changes would I make for this to work?