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...
  • 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 )
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?

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
4 years ago

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