Forum Discussion
kfschaefer
Helper IV
Helper IVConvert text to number
What is the proper syntax to convert a text into a number format? I need to convert some import data(xls) that for some reason is coming accross as text instead of a number. It is formatted in x...
Couple different methods, you can choose number or currency from the Modeling tab in the Data Type section and it will generally convert it just fine. There is also the VALUE function:
https://msdn.microsoft.com/en-us/library/ee634584.aspx
Greg_Deckler
Community Champion
Community ChampionCouple different methods, you can choose number or currency from the Modeling tab in the Data Type section and it will generally convert it just fine. There is also the VALUE function:
https://msdn.microsoft.com/en-us/library/ee634584.aspx
kfschaeferHelper IV
Helper IVThanks I found this answer at the same time you posted.
K
exl file uploaded as a text. I try to convert text to number but unsucsessfuly. Could anybody advice why exl converted to text in POWER BI after upload, and how to convert text to value
