Fill a specific cell value to entire column for a Table through Custom Column

[gmrram]

Hi I tried adding a New Column to every table in the Data Column and fill the Company Name which is available in [Column]{0} in the respective table through Custom Column. However Im getting the error as shown in the snip. Please help me on this. Thank You. Please refer attached snip.

[AlB · Accepted solution]

Place the following M code in a blank query to see the steps. Note the only change with regard to your version is in the last step, adding custom the column.

let
    Source = Excel.CurrentWorkbook(),
    #"Removed Columns" = Table.RemoveColumns(Source,{"Name"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Content", "Data"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Table With Company Name", (outer)=> Table.AddColumn(outer[Data],"Company Name", each outer[Data][Column2]{0}))
in
    #"Added Custom"

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[gmrram]

Thank You Very Much!! Its working perfectly!

[AlB]

Hi  @gmrram 

Can you please show the actual error message?

And ideally share the pbix with the table you are working on in PQ

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[gmrram]

Thanks for your Reply, here is the Excel file. (link updated)

https://drive.google.com/drive/folders/170LTcgmwt79LqF4KId4CmiZkMT0ZjXLt