Forum Discussion

DGFranco7's avatar
DGFranco7
Regular Visitor
1 year ago
Solved

Decimal value - Data vs Power Query

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
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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's avatar
    Chewdata
    1 year ago

    Hey,!

    You can either change the type to whole number:


    or use Transform -> Round (0 decimals):

     



danextian's avatar
danextian
Super User
1 year ago

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.