How to get values for multiple IDs from a different table?

Question

I have the following tables in POWER BITable 1&nbsp;IDValue111AAA222BBB444DDD333CCC&nbsp;Table 2Selected ID111,222,333222,444444,111&nbsp;I want to add a column to table 2 as follow&nbsp;Table 2&nbsp;Slected ValuesSelected IDAAA,BBB,CCC111,222,333BBB,DDD222,444DDD,AAA444,111&nbsp;Please help!Thanks in advance!

parry2k · Accepted Answer

vishnukasturi&nbsp;add new column with following expression:
&nbsp;
Column = 
VAR __temp = ROW ( "Id", Table2[Selected ID] )
VAR __c = 
    ADDCOLUMNS ( __temp, "Ids", SUBSTITUTE ( [Id], ",", "|" ) )

VAR __t = 
    SELECTCOLUMNS (
        GENERATE (
            __c,
            ADDCOLUMNS (
                GENERATESERIES ( 1, PATHLENGTH ( [Ids] ) ),
                "MyIds", PATHITEM ( [Ids], [Value], TEXT )
            )
        ),
        "Id", [MyIds]
    )
RETURN

CONCATENATEX ( CALCULATETABLE ( VALUES ( Table1[Value] ), TREATAS ( __t, Table1[ID] ) ), Table1[Value], "," )
&nbsp;

I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! 
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

Forum Discussion

How to get values for multiple IDs from a different table?

2 Replies

Related content

Waterfall with multiple values

Date Different return wrong value

Text slicer: pasting multiple values

Filter multiple values from different columns

Date difference with multiple criteria

Table 2
Slected Values	Selected ID
AAA,BBB,CCC	111,222,333
BBB,DDD	222,444
DDD,AAA	444,111

Table 1
ID	Value
111	AAA
222	BBB
444	DDD
333	CCC