Change column type to percentage

[Mic1979]

Hello all,

I would like have a custom function able to change column type to percentage only if the column header has "%" inside.

I know the function to use is Table.TransformColumnTypes. I made this:

Changed_Type1 = Table.TransformColumnTypes(
     Table_to_Change,
          {{ List.Select (Table.ColumnNames (Table_to_Change), each Text.Contains (_, "%"),

              Percentage.Type}})

The point is that List.Select (Table.ColumnNames (Table_to_Change), each Text.Contains (_, "%") return a list, while there I need to have text.

How to do this?

Thanks.

[AlienSx · Accepted solution]

Changed_Type1 = Table.TransformColumnTypes(
    Table_to_Change, 
    List.Transform(List.Select(Table.ColumnNames(Table_to_Change), each Text.Contains(_, "%")), each {_, Percentage.Type})
)

[Mic1979]

Thanks AlienSx