Extracting text after right-most delimeter

[Anonymous]

Hi!

I'm trying to extract text after the last "." in a string.

For example:
123.234.123 returns "123"

abc.44564563.ade returns "ade"

hsjs.92.345 returns "345"

For the purposes of my data, I need it to be a column (NOT made in power query!)

Any help appreciated.

[Anonymous · Accepted solution]

Hi mk720x,

If you use the following formula, you should be able to accomplish what your looking for:

NewColumn = SUBSTITUTE(RIGHT('TableName'[ColumnWithFullString], SEARCH(".", 'TableName'[ColumnWithFullString])),".","")

Here is the screenshot of my example:

Hope this helps!

[amitchandak]

Use the search and right functions. Some functions to refer

https://docs.microsoft.com/en-us/dax/search-function-dax

https://docs.microsoft.com/en-us/dax/right-function-dax

https://docs.microsoft.com/en-us/dax/substitute-function-dax

https://docs.microsoft.com/en-us/dax/mid-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601