Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Interesting Links
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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.

    need-help-round-down-number

     

    Best Regards,
    Dale

HotChilli's avatar
HotChilli
Community Champion
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

 

I've tried it but didn't work.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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.

    need-help-round-down-number

     

    Best Regards,
    Dale