Forum Discussion

dub's avatar
dub
Frequent Visitor
8 years ago
Solved

How To Get Data From Multiple Tables inside one Column?

Hello everyone,   I am trying to solve this for a while now. If anyone can help i will be very much greatful.   I need to get data from multiple tables inside another table's column.   I tried ...
Need Help
  • dub's avatar
    dub
    8 years ago

    Hi v-qiuyu-msft, Greg_Deckler

     

    Thank you for the answers!

     

    The problem is that i have much more tables involved. But i managed to get what i need by appending all the one row tables into one big table, and then use LOOKUPVALUE to pull the desired column values based on matching Ids.

     

    Thank you both for your contribution.

     

    BR

     

    Dusan

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi dub,

 

From your description, each table has [Number] column which has one value, you want to concatenate those column values in one table, right? 

 

In your scenario, assume Table2, Table3 and Table4 have Number column, you can try to create a calculated column in the table Table2 use DAX below: 

 

ConcatenateCol = CONCATENATE(CONCATENATE('Table2'[Number],CONCATENATE(",",MAX('Table3'[Number]))),CONCATENATE(",",MAX('Table4'[Number])))

 

Please take a look at attached pbix file. 

 

Best Regards,
Qiuyun Yu 

dub's avatar
dub
Frequent Visitor
8 years ago

Hi v-qiuyu-msft, Greg_Deckler

 

Thank you for the answers!

 

The problem is that i have much more tables involved. But i managed to get what i need by appending all the one row tables into one big table, and then use LOOKUPVALUE to pull the desired column values based on matching Ids.

 

Thank you both for your contribution.

 

BR

 

Dusan