Forum Discussion
Power Query shows non-zero values, Table View shows only zeros
This has happened to me a couple times now so it must be something that I'm doing in my transformations. Import a "wide" excel file, reverse pivot the columns so that the months run down not acro...
Greg,
Thanks for the reply but I said there are no "true" zeros in the data.
I acknowledge your confusion and mirror it.
Hi Anonymous
Please check that if your data format is whole number.
If is whole number, change it to decimal number, and and retain the corresponding bits.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate the reply - that didn't help.