Forum Discussion

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
4 years ago
Solved

Text Replace help

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's avatar
    tamerj1
    4 years ago

    thomas_coltrain 
    Please use the following

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

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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?

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    thomas_coltrain 
    Please use the following

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