Forum Discussion
Column from examples incorrect value
- 1 year ago
carmelo73 , Try using
Use Locale Settings: When changing the data type, specify the locale to ensure that Power Query interprets the decimal separator correctly. You can do this by:
Right-clicking the column header.
Selecting "Change Type" > "Using Locale..."
Choosing "Fixed decimal number" and setting the appropriate locale that matches your data's format.
Replace Values: If the text values use a different decimal separator (e.g., a comma ,), you can replace it with a period . before changing the data type:Select the column.
Use the "Replace Values" feature to replace commas with periods.
Then change the column type to "Fixed decimal number".
Hi carmelo73 ,
Thank you for reaching out to the Microsoft Fabric community forum
I wanted to check if you had the opportunity to review the information provided by bhanu_gautam . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.