Export Number from text as paragraph

[Hindlaz]

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.

[djurecicK2]

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