Column from examples incorrect value

[carmelo73]

Good evening, in Power Query I use the function column from examples, from all columns. I type the value 412.13 and the correct value is shown in all rows. If I transform the column from text (abc) to fixed decimal value , the value becomes 41.213,00.

Thank you. 

[Anonymous]

Hi @carmelo73 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Hi @carmelo73 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

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.

[bhanu_gautam · Accepted solution]

@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".