Forum Discussion
Add column to data set using append
I have a pbix set to append files from within a folder. Folder currently contains 3 files 2018 Revenue 2019 Revenue 2020 Revenue I have added 2 additional columns to the end of the data set...
I do not see any of my current column names within the code.
let
Source = Folder.Files("F:\E-Marketing\Numbers\PowerBI\Annual Sales Data - Copy"),
#"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
