Forum Discussion
Please Help - Change WHOLE numbers to DECIMAL
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?
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.
2 Replies
- amitchandak
Super User
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
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.
