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.
V-yubandi-msft
Community Support
Community SupportHi basaknilabja ,
Did you get a chance to check out the response I sent earlier? If it solved your problem, you might want to mark it as the accepted solution. It'll help others in the community who might have the same issue.
Thanks