Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

decimal management

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.

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.