Calculated Dax column to extract last word in text string from another column

[Anonymous]

I have a column called [Subscription Name] with three words in it and I want a new column with just the last word in it. 

See my vision below.

I want to do this as a Dax calculated column because in Query Editor it takes forever to load and apply my dataset because it's huge. 

Subscription Name1	Subscription Name2
Company International Development	Development
Org Global Production	Production
Company European Operations	Operations

I've found a few threads with similar queries but none just for extracting the last word. 

Any help would be really appreciated 🙂

[sagar_ap]

If you try using column from examples, it will find the formula for you immediately.

[Anonymous · Accepted solution]

Hey,

Besides the fact that it would be way better to do this using the query editor here is a DAX statement for a calculated column.

Derived Column = 
VAR firstspace = FIND(" ";'Table'[Subscription Name1];1)
VAR secondspace = FIND(" ";'Table'[Subscription Name1];firstspace+1)
VAR lenght = LEN('Table'[Subscription Name1])
RETURN
MID('Table'[Subscription Name1];secondspace + 1;lenght - secondspace +1)

Btw, if this post helps please consider marking it as a solution AND copying it to the other topic as there are by accident two copies of this question.