This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a data set that I perform a calculation on to generate a new column of numbers. I usually import it into Power Query and use the Unpivot feature so I have two rows for each data point, "NetMFI" and "NormalizedNetMFI" (the calculated field). I've done this many times before without issue but now when I perform my calculation, I see the correct numbers in the NormalizedNetMFI column, but when I pull it into Power Query all of my normalized values turn into 0's and 1's.
Does anyone have any idea why Power Query would be erasing/modifying the values I just calculated?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Check the options in Power Query, you can disable the automatically creation of the "Change Type" step in the Global section.
Andreas.
I figured it out, Power Query threw in a "change type" step and was changing my normalized column to a Int64 type for some reason.
This has nothing to do with Power Query, it's up to your data.
If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.