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

Razwan's avatar
Razwan
Helper I
6 years ago

Tejasvi_munge 
Hi, since you are using a live connection, the only way to build a column is in its data source and not on the report-side. 
However, you may try to build a measure on the report-side, something like:

# MyMeasure = 
      CALCULATE(
          MAX('MyTable'[MyColumn])
      )

Then you can format it using the Modeling ribbon as you wish and append it to your table in the report.


Kind regards,
Razwan