Forum Discussion

dub's avatar
dub
Frequent Visitor
9 years ago
Solved

Dynamicaly pull data from other tables based on a field value

I have a table Combine and tables Table 1, Table 2, Table 3, ... Table 10. Each of the tables Table 1, ... Table 10 has one row with multiple columns. Lets say on of the columns is Table1[Id] ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi dub,

     

    After loading all these tables (Combine, Table1, Table2,...Table10) into Power BI desktop, you should first Append tables from Table1 to Table10 in Query Editor mode. Suppose the new appended table is called Table11, then, in report view mode, you can use LookUpValue function to  create a new calculated column Combine[Values] in Combine Table.

     

    Values=LOOKUPVALUE(Table11[Number], Table11[Id], Combine[Id])

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi dub,

 

After loading all these tables (Combine, Table1, Table2,...Table10) into Power BI desktop, you should first Append tables from Table1 to Table10 in Query Editor mode. Suppose the new appended table is called Table11, then, in report view mode, you can use LookUpValue function to  create a new calculated column Combine[Values] in Combine Table.

 

Values=LOOKUPVALUE(Table11[Number], Table11[Id], Combine[Id])

 

Best regards,
Yuliana Gu

dub's avatar
dub
Frequent Visitor
8 years ago

Thanks. It did the work :)