How to refer to a table by a cell value in another table via Power Query

[Anonymous]

Hi, I have a table called Table1 with a column called "Table name" saving names of other tables. I am looking to read name from a cell in Table1[Table name], save in a string variable and then refer to that table by the string variable. I am wondering how to do that in M Language or DAX? Thanks! 

[mohammedadnant · Accepted solution]

@Anonymous 

Try using LookupValue DAX and then ConcatenateX DAX to bring all the value in a string.

LookupValue : https://youtu.be/jPrxonHLGDs

ConcatenateX : https://youtu.be/hPQXNDLiHkI

Multiple values in 1 row Power Query : https://youtu.be/g3uofBDly9w

Thanks & Regards,

Mohammed Adnan

Learn Power Platform from my channel TAIK18 click on the link

[Anonymous]

Thanks for your reply. Once i get the table name in the string, how to refer to it in DAX and M? E.g.

TableName = "Table2"

Can I do something like #TableName to refer to that table?

[CNENFRNL]

Use Expression.Evaluate function to reference another table with a string variable in Power Query

[Anonymous]

Thanks for your reply. I am a Power Query beginner. Can i ask what does #Shared mean in the expression.evaluate function? 

[Anonymous]

LOOKUP,RELATED or SELECTEDVALUE functions may work for you. Do you have a sample dataset to share?