Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Rounding

I am still having trouble with my percentages rounding when I close and apply. Is there a calculation I can use to stop this from happening. I need the data to be exact to match the source. 

  • Hi, Anonymous ;

    You need to adjust the number type in desktop not in power query.

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • ddpl's avatar
    ddpl
    Solution Sage

    Anonymous try this one in power query

     

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, Anonymous ;

    You need to adjust the number type in desktop not in power query.

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.