Hey,
w3hgJRT.png
I'm using table in excel as my PowerQuery data, I have about 60k rows, it's formatted as numbers and while I have decimal numbers like "0.25" PowerQuery sees it as 0, even when that column is formatted as decimal numbers. Later when I convert PowerQuery into PivotTable it shows wrong and misleading numbers: 0 instead of 0.25. I can see that PowerQuery has option to "Round up" or "Round down" but it does nothing in this situation. Why is that happening?
Edit: I've actually managed to fix it by adding additional step and changing formatting to decimal numbers earlier. So please delete/close this topic. Sorry for trouble.
Bookmarks