How do I round a column which contains long decimal numbers to 2dp in Power Query?

[HamidBee]

I have a column in Power Query with values that contain many decimal places. Does anyone know how I can round up to the nearest two decimal places in Power Query?

Thanks

[vojtechsima · Accepted solution]

Hi, @HamidBee ,
just use Number.Round function:

Number.Round(1.2345, 2)
that will return 1.23

[HamidBee]

Nice. Thank you very much.