cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mrnascimento3 Frequent Visitor
Frequent Visitor

Need Help Round Down Number

Hi,

 

I had a number got from SQL, and I'd like to round down it. In Excel is pretty easy. I'll show an example:

 

A1=830 = ROUNDDOWN(A1/100;0) =8

A2=1020 = ROUNDDOWN(A2/100;0)=10

 

I need it in the new measure, or "M languege" because I'll use it in order to plot a graph.

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Need Help Round Down Number

Hi @mrnascimento3,

 

It's this one in M.

Number.RoundDown([Column1] / 100)

And this one in DAX.

Column = ROUNDDOWN([Column1]/ 100, 0)

Please refer to the snapshot below.

need-help-round-down-number

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
HotChilli Senior Member
Senior Member

Re: Need Help Round Down Number

Number.RoundDown(value) ,if you want to go to the integer lower than your number

mrnascimento3 Frequent Visitor
Frequent Visitor

Re: Need Help Round Down Number

 

 

I've tried it but didn't work.

Community Support Team
Community Support Team

Re: Need Help Round Down Number

Hi @mrnascimento3,

 

It's this one in M.

Number.RoundDown([Column1] / 100)

And this one in DAX.

Column = ROUNDDOWN([Column1]/ 100, 0)

Please refer to the snapshot below.

need-help-round-down-number

 

Best Regards,
Dale

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