[ Help extracting part of a text from a column ]

[bolabuga]

Hello everyone.

I would like help extracting the houses adresses from a "address column", and i need just the text at the start till the "," character.

Ex:

Travessa john charles de mello, 457 A - neighborhood ABC - City xyz, Sao paulo---> I need the part of the text till the first "comma", which is "Travessa john charles de mello".

I never had the need to do such a thing in power bi, and im somewhat lost here, because theres a lot of different adresses and i would like to know if theres a way to use the FIRST COMMA as a POINT where we can count the characters till there and then maybe use that count in a LEFT dax function.

Any help is welcome, it can be dax or power query.

[AlB · Accepted solution]

Hi @bolabuga 

Sure, you can use FIND:

     FIND(",", Table1[Col],1,0) 

to get the position of the first comma and then use that (-1) with  a LEFT( )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[CNENFRNL · Accepted solution]

Hi, @bolabuga , Power BI toolkit consists of another powerful lightsaber, Power Query, which does the trick.

It's power is beyond imagination when you have a firm grasp of functions in M language. I bet you'll love it.

[bolabuga]

@AlB 

@CNENFRNL 

Wow you both were amazing...REEEAALLY thks!!!

[AlB · Accepted solution]

Hi @bolabuga 

Sure, you can use FIND:

     FIND(",", Table1[Col],1,0) 

to get the position of the first comma and then use that (-1) with  a LEFT( )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers