Forum Discussion
Hindlaz
2 years agoFrequent Visitor
Export Number from text as paragraph
Hello,
I'm begginer her so I need your helps pls. I dont have right to transform data so I can only create new column
I have a column format text but it contains numbers with (.) as paragraph, I would like to transfer this column to number in order to sort my Data per the number. Because when I sort my data with the column as it is,.
I tried Newcolumn = LEFT(column2[ID],3 SEARCH(",",column2[ID])-1) but message error show that i cant transfer text to number
It shows like this
Thank you in advance.
1 Reply
- djurecicSuper User
Hi Hindlaz ,
You can try using the Value function to convert text to a number:
https://learn.microsoft.com/en-us/dax/value-function-dax