Forum Discussion
Solved
A numeric looking text column cannot be converted to number
A numeric looking text column cannot be converted to number as I tried but it can't be solver even after Text.Select Cleaning and Number.FormText. So I can't use in visual as its not showing the nume...
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.
ryan_mayu
Super User
Super Userwhat's the error message after you use Number.From?
if there is no error message, have you tried to change the data type in column tools?