cancel
Showing results for
Did you mean:
Member

## How to control Number.RoundUp() function in M Language

Using Number.RoundUp the calculation below will transform:

2.4 into 3

2.6 into 3

2.75 into 3

I would like to manage the result of the function Number.RoundUp to get it works only between a specific range instructed by me. For example in case the result of calculation is >= 2.75 then Number.RoundUp should come out 3. If not, the value should be left as it is

```#"Added Conditional Column6" = Table.AddColumn(#"Changed Type11", "Fcst3Y_At_EOFY", each if [Seniority] < 3
and  ([Seniority] + [SnrtyAt_EOFY]) <= 3
then Number.RoundUp(([Seniority] + [SnrtyAt_EOFY]))
else null),```

Thanks

gpiero

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super Contributor

## Re: How to control Number.RoundUp() function in M Language

Hi @gpiero ,

Based on my research, this function will returns the larger integer, if you want to control your data, I suggest you use if function:

`= Table.AddColumn(#"Changed Type", "Custom", each if [Date]>=2.75 then Number.RoundUp([Date]) else [Date])`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super Contributor

## Re: How to control Number.RoundUp() function in M Language

Hi @gpiero ,

Based on my research, this function will returns the larger integer, if you want to control your data, I suggest you use if function:

`= Table.AddColumn(#"Changed Type", "Custom", each if [Date]>=2.75 then Number.RoundUp([Date]) else [Date])`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 253 members 2,614 guests
Recent signins: