Please Help - Change WHOLE numbers to DECIMAL

[bill-allen-21]

Hello,

I am pulling a time activities report from quickbooks online to Power BI, and the hours are not showing as decimal, and round down therefore giving me "0" numbers effecting my sum totals.  I have changed the Data Type to "Decimal Numbers", and the "Rounding" to 2 decimal places, but it still shows whole numbers.  Can you please help?  

[Anonymous · Accepted solution]

@bill-allen-21 

What is the date type or format of the duration column in the quick book? Try change the data type to TEXT.

And you should get a simple text column in power bi.

Then just change the data type to duration.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bill-allen-21 , Right click on the table and open Advance Editor , And check the datatype in first time when they are assigned.

Make it decimal or float there.

Few steps covered in

How to manage when column is added or removed at source: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2