DAX calculated column to extract last word from text string

[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 🙂

[amitchandak]

Refer :

https://community.powerbi.com/t5/Desktop/Power-Query-Remove-last-word/td-p/315722

[Anonymous]

Hi,

try this formula

column =

PATHITEM( SUBSTITUTE( [Subscription Name1]; " "; "|" ) ;3 )

Hope it helps 🙂

/Adam