decimal management

[Anonymous]

Hello guys,

I have an issue with a decimal.

When I calculate with excel the result show is more accurate than PBI as you can see below in screenshot.

So I need your help to fix this issue.

[v-yangliu-msft]

Hi  @Anonymous ,

I can't replicate your scenario, on my side it's the same as the excel result

[Taux dimputation CT] What formula is composed, whether it is a calculated column or a measure, and whether the Fomart function is used.

You can try in this column, change it to Percentage, write 4 below.

Or use the VALUE function, will it display normally:

Measure =
VALUE([Taux dimputation CT])

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Make sure it is decimal in the power query.

And In Dax/column tool it should decimal , decimal, and increase number of decimal place