Solved: Rounding

jack1e · ‎08-25-2022

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 · ‎08-30-2022

Hi, @jack1e ;

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.

How to get your questions answered quickly -- How to provide sample data

View solution in original post

v-yalanwu-msft · ‎08-30-2022

Hi, @jack1e ;

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.

How to get your questions answered quickly -- How to provide sample data