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):

     



2 Replies

  • 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.

  • Chewdata's avatar
    Chewdata
    Responsive Resident
    1 year ago

    Hey,!

    You can either change the type to whole number:


    or use Transform -> Round (0 decimals):