topic Re: Separate the text value in the column in DAX Commands and Tips

Separate the text value in the column

DimaMD — Tue, 03 May 2022 06:54:16 GMT

Hi Community

Please help, I need to separate the text value, the text value can be of different lengths
Separate values is required when searching for a numeric value.
As a result, I have to get text values excluding numeric values.
I know that this can be done in Power Query, but with this separation I do not perform Incremental Update

Values	Result
a s d 321 asd	a s d
z x c 654 zxc	x z c
q w e 963 qwe	q w e
a w s d 325 asdf	a w s d

thanks for the help,
Greetings from Ukraine

Re: Separate the text value in the column

Anonymous — Mon, 02 May 2022 07:23:47 GMT

Hi DimaMD ,
is the length of numeric part fixed at 3 characters?

Re: Separate the text value in the column

Anonymous — Mon, 02 May 2022 07:26:04 GMT

If yes, you can use this DAX

Text part only = var _numpart = RIGHT('Table'[Values],3) return SUBSTITUTE('Table'[Values],_numpart,"")

Regards

Re: Separate the text value in the column

DimaMD — Mon, 02 May 2022 07:28:49 GMT

Hi Anonymous no, it can be whole text words

for example:
No War 321 No War,
We are from Ukraine 321654, We are from Ukraine
As a result, I have to get in the column
No War
We are from Ukraine

Re: Separate the text value in the column

DimaMD — Mon, 02 May 2022 08:16:04 GMT

Anonymous
Thanks for the help, well, this DAX does not work with my data, there may be several text values

Re: Separate the text value in the column

tamerj1 — Wed, 04 May 2022 13:52:30 GMT

Hi DimaMD
One way to do that: New column >

Result = VAR NumberSeries = GENERATESERIES ( 0, 9, 1 ) VAR LocationTable = ADDCOLUMNS ( NumberSeries, "@Location", FIND ( [Value], Data[Values], 1, 10000 ) ) VAR StringEnd = MINX ( LocationTable, [@Location] ) - 1 RETURN LEFT ( Data[Values], StringEnd )

Re: Separate the text value in the column

DimaMD — Fri, 06 May 2022 11:30:55 GMT

HI, tamerj1
I am very grateful to you, your DAX worked, and that made it easier for me to work with the update

Re: Separate the text value in the column

Anonymous — Fri, 06 May 2022 12:01:39 GMT

Such an ingenious solution! Your level of technological prowess in this technology is truely tremendous.

Re: Separate the text value in the column

tamerj1 — Fri, 06 May 2022 12:09:05 GMT

😍