CONCATENATE help with weird table structure

[Lucinda_Mason]

I have a legacy table with a strange data structure. I’m trying to make a virtual column but can’t get it to work. I don’t know if it because of the GEO table structure or simply because [Country_Geo_NO] can be a list, not just a single value. Let’s assume that is the issue.

This is in another table. There can only be ONE Geo_NO per request. The [Country_Geo_NO] is based on the Geo_NO. There can be one or MORE [Country_Geo_NO] per request. I think that is where at least part of my problem is.

The expression below:

1. only shows ONE [Country_Geo_NO], even when there are multiple.
2. only shows the number and not the name. I’ve tried multiple ways but can’t get the [Geo_Name] to show

CONCATENATE([Geo_NO].[Geo_Name], " – ", [Country_Geo_NO])

Thanks for pointing me to the right direction.