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,