Forum Discussion
Lookup value from a text field with ID's
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
3 Replies
Anonymous , 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]) )
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.
