Create A Custom Column Based on the Name of Another Table

Question

Hello,&nbsp;I am trying to create Source to Destination table of my Data Sources (Similar to what the Query Dependencies view does in Power Query View Tab).&nbsp;The source column contains all of my data sources (as an appended table),&nbsp; what i want the destination column to return is name of the "Final Table" that all of those data sources flow into, but this is proving oddly difficult. Please assist.&nbsp;&nbsp;&nbsp;

wdx223_daniel · Answer

=Table.AddColumn(#"Renamed Columns","Custom",each Record.FieldOrDefault(#shared,[Source],null))

cflynn_29 · Answer

It didnt work, is it because the&nbsp;=Table.AddColumn(#"Renamed Columns","Custom",each Record.FieldOrDefault(#shared,[Source],null)) is in another table?

Forum Discussion

Create A Custom Column Based on the Name of Another Table

2 Replies

Related content

How creating a Python custom library

Creating a custom column

create custom column concatenated

Creating Custom columns

Creating a custom leaderboard