Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Dynamic transformation and rounding

Hello all,   I need to change the type only on the columns with  $ in the header.   I have the following code:   TransformDollars = Table.TransformColumnTypes( renameColumns, List.Transform( ...
Need Help
  • AlienSx's avatar
    AlienSx
    1 year ago
        RoundDollars = Table.TransformColumns (
        TransformDollars,
        List.Transform (
            Dollars_Columns_Selected,
//         each {_, Number.Round(_, 3), type number})) >> this is wrong, must be 
            each {_, (x) => Number.Round(x, 3), type number}
        )
    )
Mic1979's avatar
Mic1979
Post Partisan
1 year ago

Hello,

I don't see any function in your file.

I know this is possible with standard approach from Power Query, but I am trying to built a function...

 

Thanks.