Column data = table name

[jayped]

Hi there,


I want to append three tables but I want to add a column to each table which differentiates them by using the table/ source name. I am new to Power Bi and when trying to research this I do not understand most of the solutions provided.

I have three files: Oct, Nov and Dec. I do not have a date column. I also want to avoid manually changing the month in the new column every month. How can I achieve this?

 

[sandy666]

this is example only

let
    Source = Excel.Workbook(File.Contents("D:\test\pbi\test.xlsx"), null, true),
    Filter = Table.SelectRows(Source, each ([Kind] = "Table")),
    ROC = Table.SelectColumns(Filter,{"Data", "Item"}),
    Expand = Table.ExpandTableColumn(ROC, "Data", {"item1", "item2", "item3"}, {"item1", "item2", "item3"}),
    Reorder = Table.ReorderColumns(Expand,{"Item", "item1", "item2", "item3"})
in
    Reorder