Forum Discussion
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 LOOKUPVALUE() but it can take data only from one table. It somehow needs a loop which will dynamicaly choose a table and column to look at. (The column name is the same for all tables).
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
6 Replies
- Greg_Deckler
Community Champion
Need more details on this: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
CONCATENATE?
Thank you Smoupre,
I tried thisColumn = CONCATENATE() which returns a string (in my case a table and column name) - f.ex. 'Table[Number]' - but what i need is a value.
SUM('thisColumn') would do the work, but it returns an error "The function SUM cannot work with value of type String".
Is there any function or DAX thing to get the expression of a String? Or any other Idea?
Thank you for your help.
Dusan
- Greg_Deckler
VALUE will turn a string into a numeric value if possible.
