Rounding

[Anonymous]

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. 

[v-yalanwu-msft · Accepted solution]

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.

[ddpl]

@Anonymous try this one in power query