Creating custom function for changing multiple columns format instead of using changing locale

[_isildur]

Hi Community,

I have been searching around but have not found a solution yet.

Is it possible to create a custom M function which changes the Locale Format of multiple columns instead og going in and doing it for each column? 

Usually it will be when a number format is 1,000.00 I would like it to be 1.000,00.

Another example could be a date format in mulitple columns that needs to be changed.

BR

[Anonymous · Accepted solution]

It's the final optional argument to: Table.TransformColumTypes( table, list, culture )

= Table.TransformColumnTypes(Source,{
        {"Date", type date},
        {"Currency", type number},
        {"Time", type time}
    },
    "fr"
)