topic Re: Text Replace help in DAX Commands and Tips

Text Replace help

thomas_coltrain — Fri, 29 Jul 2022 18:36:05 GMT

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

4 and so on

I tried the text.replace and kept getting an error

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

Thanks,

Re: Text Replace help

tamerj1 — Fri, 29 Jul 2022 18:46:05 GMT

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?

Re: Text Replace help

thomas_coltrain — Fri, 29 Jul 2022 18:47:37 GMT

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

Re: Text Replace help

tamerj1 — Fri, 29 Jul 2022 18:54:52 GMT

thomas_coltrain
Please use the following

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

Re: Text Replace help

thomas_coltrain — Fri, 29 Jul 2022 19:07:18 GMT

Fast service!! Thank you for the help!