Forum Discussion

KG1's avatar
KG1
Resolver I
4 years ago
Solved

Rounding Issue ( I think)

Hi In my data the Orginal value and New AFP Value columns have a number of decimal places.  I used the rounding function to 2 decimal places, then I created a new custom column (Status) which says ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    You probably need one of the ROUND functions to convert the values. If you use the formatting options it just creates the format for displaying purposes, but doesn't actually convert the number itself.

     

    https://dax.guide/round/ 

  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi KG1 

    Thanks for reaching out to us.

    If you use the round() function instead of just adjusting the display format, the result should not be wrong.

    Could you share the sample file? so that we can test it to find the reason.

     

    Kindly note: You can replace the raw data with bogus data to protect your private information. Thanks 🙂

     

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi KG1 

Thanks for reaching out to us.

If you use the round() function instead of just adjusting the display format, the result should not be wrong.

Could you share the sample file? so that we can test it to find the reason.

 

Kindly note: You can replace the raw data with bogus data to protect your private information. Thanks 🙂

 

 

Best Regards,

Community Support Team _Tang

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

KG1's avatar
KG1
Resolver I
4 years ago

Hi

I used the round.up fucntion and it fixed the problem

 

Number.RoundUp([AFP Value],2)

 

Thanks for your help