Trying to extract the first 6 digits of this column, without using power query, from this 10 digits

[realme1]

I have this is powerbi , the column is mentioned material, I only need the first 6 digit of that, not the last 4. How should I do it without powerquery 

How should I code this in DAX using measures/ columns

Thanks in advance

[Idrissshatila · Accepted solution]

Hello @realme1 ,

use the following formula 

Column = LEFT('YourTableName'[Material],6)