Forum Discussion
Rounding
Hi Mic1979 ,
In Power Query (M language), you can create a custom column using the Table.AddColumn function. This formula checks the decimal part of the number using Number.Mod([YourColumn], 1). If the decimal part is ≥ 0.4, it rounds up by adding 1 to the integer part; otherwise, it rounds down to the integer using Number.RoundDown([YourColumn]). Here's the code:
= Table.AddColumn(Source, "Custom_Rounding", each if Number.Mod([YourColumn], 1) >= 0.4 then Number.RoundDown([YourColumn]) + 1 else Number.RoundDown([YourColumn]), type number)This ensures numbers like 12.4 round to 13, 12.3 stays 12, 5.6 becomes 6, and 5.2 remains 5.
Best regards,
Hi Mic1979 ,
In Power Query (M language), you can create a custom column using the Table.AddColumn function. This formula checks the decimal part of the number using Number.Mod([YourColumn], 1). If the decimal part is ≥ 0.4, it rounds up by adding 1 to the integer part; otherwise, it rounds down to the integer using Number.RoundDown([YourColumn]). Here's the code:
= Table.AddColumn(Source, "Custom_Rounding", each
if Number.Mod([YourColumn], 1) >= 0.4
then Number.RoundDown([YourColumn]) + 1
else Number.RoundDown([YourColumn]), type number)
This ensures numbers like 12.4 round to 13, 12.3 stays 12, 5.6 becomes 6, and 5.2 remains 5.
Best regards,
Thanks. I will accept this.
