Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I get data from Excel, which contains decimal data (different number of decimal places). to get some unique key, I need to combine the text and decimal values into one column. but power query incorrectly imports decimal values, adding additional characters. examples in the screenshots.
PS: this problem is observed if the data table is not in the same book where the request is made
Solved! Go to Solution.
Check the custom number format.
It might be caused by the data souce. You may use Number.Round to deal with it.
but how do I round the number if I do not know what number of decimal places will be?
Check the custom number format.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |