Forum Discussion

Tejasvi_munge's avatar
Tejasvi_munge
Frequent Visitor
6 years ago
Solved

keep zero after decimal

Hi All,   I have a column containing values like 2.3456, 2.304 etc And I want to limit values upto two decimal points. Also, I cannot use option which modelling ribbon provides beause I am connect...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    You can change measure's format:

    Or use VALUE function:

    measure 2 = VALUE([measure])

    Or if you just want to sort, please try to create a rank measure:

    rank = RANKX(ALLSELECTED('Table_1'),VALUE([Measure]),,DESC,Dense)

    And then sort number by this rank.

     

    Best Regards,

    Giotto Zhi

Tejasvi_munge's avatar
Tejasvi_munge
Frequent Visitor
6 years ago

Hi,

 

Thank you for suggestion! 

But Fixed changes the data type into text and will not give correct output while sorting 

For ex- consider values like 9.8, 9.1,10.3

Sorting(desc order) after using Fixed will give output like-9.8, 9.1, 10.3 and not 10.3, 9.8, 9.1   

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

You can change measure's format:

Or use VALUE function:

measure 2 = VALUE([measure])

Or if you just want to sort, please try to create a rank measure:

rank = RANKX(ALLSELECTED('Table_1'),VALUE([Measure]),,DESC,Dense)

And then sort number by this rank.

 

Best Regards,

Giotto Zhi