Changing Data types of all columns except the column with the name "Date"

[Juleeees]

Hi, 

I want to change all column types from text to currency.type except the column with the name "Date". The Column "Date" is the first column. 

The idea is

Table.TransformColumnTypes(#"Neu angeordnete Spalten",List.Transform(List.Skip(Table.ColumnNames(#"Neu angeordnete Spalten"), [Date] ), each {_, Int64.Type}))

Thanks in advantage.

Julian

[AntrikshSharma · Accepted solution]

@Juleeees Use this:

let
    Source =  .....,
    ColumnTypes = 
        List.Transform ( 
            Table.ColumnNames ( Source ), 
            each 
                if _ = "Date" 
                then { _, type date } 
                else { _, Currency.Type } 
        ),
    ChangeType = Table.TransformColumnTypes ( RemovedColumns, ColumnTypes )
in
    ChangeType