Decimal value - Data vs Power Query

[DGFranco7]

Dear all,
How can you get a closed value of 0 if the power query has decimal places in the values?

There are no steps in between for this behavior.

Power Query: 

Data: 

Thanks

[danextian · Accepted solution]

Hi @DGFranco7 

What do you meay by closed value of 0? If you're trying to remove the decimal places as in the second table, you can just change the data type to whole number. Otherwise, please provide more context.

[Chewdata · Accepted solution]

Hey,!

You can either change the type to whole number:

or use Transform -> Round (0 decimals):

[danextian · Accepted solution]

Hi @DGFranco7 

What do you meay by closed value of 0? If you're trying to remove the decimal places as in the second table, you can just change the data type to whole number. Otherwise, please provide more context.