Need Help Round Down Number

[Anonymous]

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,

[HotChilli]

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

[Anonymous]

I've tried it but didn't work.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

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.

Best Regards,
Dale