Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DimaMD
Solution Sage
Solution Sage

Separate the text value in the column

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

 

ValuesResult
a s d 321 asda s d
z x c 654 zxcx z c 
q w e 963 qweq w e
a w s d 325 asdfa w s d

 

thanks for the help, 
Greetings from Ukraine


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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 )

1.png

View solution in original post

8 REPLIES 8
tamerj1
Super User
Super User

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 )

1.png

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

😍

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

 


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
Aditya_Meshram
Solution Supplier
Solution Supplier

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

Hi @Aditya_Meshram  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


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

If yes, you can use this DAX 

Aditya_Meshram_0-1651476265444.png

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


Regards

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


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors