Lookup value from a text field with ID's

[DivyaNair2022]

Hi

I am trying to display the lookup table values in to a Dashboard.

My table structure is 

 I want to display the column as highlighted in yellow

Hope someone can help me with this

Thanks

Divya

[DivyaNair2022]

i found an alternate way for acheiving this

[amitchandak]

@DivyaNair2022 , You need to duplicate the column in the first table and split it by delimiters (The copied column) , and join it with table 2 with the splitted column

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Then you can display this measure

concatenated(Table1, related(Table2[Name]) )

[DivyaNair2022]

Thanks @amitchandak for helping me with this. 

When we split the column we are actually giving the number of columns to 7 or whatever it is but in my case we don't know how many services the users are going to select so there is no specific number of columns that we can give.