Forum Discussion

carmelo73's avatar
carmelo73
New Member
1 year ago
Solved

Column from examples incorrect value

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) t...
  • bhanu_gautam's avatar
    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".