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 in the new measure, or "M languege" because I'll use it in order to plot a graph.

 

Thanks,

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

3 Replies

  • 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