Forum Discussion
A numeric looking text column cannot be converted to number
I apologize for the delayed response due to my busy schedule. I'm experiencing an issue with a measure in Power BI. There's a relationship between the 'Value' field in the 'Time_period' table and the 'Value' field in the 'Master_Table'. However, when I try to use the measure to fetch the selected value from 'Time_period'[Value] independently, it returns a blank value.
When I break the relationship then and its working fine. No need to convert the value field in Master_table into numeric value.
Helper IIYou can convert a text column containing numbers into a numeric data type using Power Query Editor
Open Power Query Editor,Click on Transform Data in Power BI Desktop to open the Power Query Editor.
Select the Text Column,Click on the header of the column that contains the numeric values stored as text.
Change Data Type,In the Transform tab, click on Data Type.
Choose the appropriate numeric type (e.g., Whole Number, Decimal Number, or Currency) from the dropdown menu.
Power Query will attempt to convert the text values to numbers.
Note: If the column contains any non-numeric text values, Power Query may return errors or null values for those rows.