Text Replace help

[thomas_coltrain]

Hey,

I need assistance in removing "years" from the data output in a column.  The data comes in labeled as..

1 Year

2 Year

3 Year etc,

I need it to just display a # like

1

2

3

4 and so on

I tried the text.replace and kept getting an error 

Text.Replace([# of Years], {"Year", ""})

Thanks,

[tamerj1 · Accepted solution]

@thomas_coltrain 
Please use the following

Year Number = 
VAR String = Data[Year]
VAR NumberLength = SEARCH ( "Y", String, 1, 3 ) - 2
RETURN
    LEFT ( String, NumberLength )

[thomas_coltrain]

Fast service!! Thank you for the help!

[tamerj1]

@thomas_coltrain 
You are posting in dax forum but seems you are looking for power quer solution. However this can be solved in dax. Are you intersted in dax solution?

[thomas_coltrain]

Opps!  Sure I don't mind if its in DAX