Forum Discussion
RELATEDTABLE
Hi, I have a table of loan numbers, and I need to return a list of tenants for each address (CODE), so I'm trying to retrieve data from the Many side and bring it into the One. When I use RELATE...
Try this
1) TenantsList =
CONCATENATEX(
RELATEDTABLE(Tenants),
Tenants[TenantName],
", "
)
2) if above one fails try this
TenantsPerAddress =
VAR Tenants =
SUMMARIZECOLUMNS(
'TenantTable',
"Tenant", [TenantName] -- Replace with actual tenant name column
)
RETURN
CONCATENATX(
Tenants,
Tenants[Tenant],
", " -- Adjust delimiter as needed
)
If it helps you please Aceept it as Solution so others can get the solution of this problem
Thank you