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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

Tejasvi_munge 

I cannot check using a live connection (don't have such a model...) but can you check if you can format your measures in the modeling pane? Select a measure, expand the properties pane, choose "Formatting" and proceed as needed...

 

  • Tejasvi_munge's avatar
    Tejasvi_munge
    Frequent Visitor
    6 years ago

    As I am live conntected there is only visual pane