Using look up value to pull all the values not the first or last value

[kkalyanrr]

Hello Team,

I'm trying to import values from Notes table using lookup value function in to Main table, but the dataset has multiple values. 
And now the interesting thing is I would like to see all the values from the Notes table(not the last one/first one).

NotesMainNew Table

[Zubair_Muhammad · Accepted solution]

@kkalyanrr

You can not add more rows in your main Table via a calculated column.

However you can do something like this (assuming 2 tables are related by ID Column)

Calculated Column =
CONCATENATEX ( RELATEDTABLE ( NotesTable ), NotesTable[Note], ", " )