Power Query Link to Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2156173%22%20slang%3D%22en-US%22%3EPower%20Query%20Link%20to%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156173%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22resolved%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%20class%3D%22resolved%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20several%20tables%20in%20Power%20Query%2C%20and%20i%20have%20a%20seperate%20query%20table%20with%20the%20base%20tables%20appended%20together%2C%20all%20in%20the%20same%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20a%20column%20in%20the%20appended%20table%20which%20would%20allow%20me%20to%20click%20and%20jump%20to%20the%20source%20table%2C%20IE%20a%20hyperlink%20to%20the%20base%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20on%20the%20best%20approach%20to%20this%2C%20whether%20some%20kind%20of%20drill%20down%20or%20just%20a%20hyperlink%20to%20the%20table%3F%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2156173%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
 
 

Hi, 

 

I have created several tables in Power Query, and i have a seperate query table with the base tables appended together, all in the same workbook. 

 

I am trying to add a column in the appended table which would allow me to click and jump to the source table, IE a hyperlink to the base table. 

 

Not sure on the best approach to this, whether some kind of drill down or just a hyperlink to the table?

 
 
1 Reply
You might try manually adding an additional column with a formula such as this one:
=HYPERLINK("#"&[@[TableName]],"Link to "&[@[TableName]])
this formula assumes there is a column in your query named "TableName" which contains the name of the tables.