Query: Add column at the beginning

Gangula,

To do that you would need to add two additional steps between your data table and reordering like below:

let    
   ...
    TableData = Table.AddColumn(TransformColumnTypes, "Half Year", each if [Month] < 7 then 1 else 2),
    ColumnNames = Table.ColumnNames(TableData),
    ReorderedList = List.Combine({{"Half Year"},List.FirstN(ColumnNames,List.Count(ColumnNames)-1)}),
    Result = Table.ReorderColumns(TableData,ReorderedList)
in
 Result

where

- TableData is the last step of your data, in my case, it is a step where I've added a new custom column

- Half Year is my custom column which I want to be first each time

- ColumnNames is a step which contains a list of columns from TableData

- ReorderedList is a step which represents column names where my custom column comes first and all other column next (does not matter how many)

- Result is a step represents sorted TableData based on ReorderedList 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!