March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
I have a power query with a value as shown below....
When I import this column / values to my power bi table it is setting all the value below 0 (0.4 etc) as 0 and not totalling them up as required? Even thought he column is set to decimla and 2 decimal places etc?
Solved! Go to Solution.
Usually after you import data, PQ will change the data type automatically.
you can try to delete the change type step to see if the data is correct.
Proud to be a Super User!
Usually after you import data, PQ will change the data type automatically.
you can try to delete the change type step to see if the data is correct.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
86 | |
77 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |