Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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