DAX formula to get certain characters from a column

[juhoneyighot]

Hello!

I have a column with the following details. Please see table below. I just want to get "LBP_" from column Name. 

Name	What I want
LBP_101 Shady Ln_Mills_JF	101 Shady Ln_Mills_JF
LBP_111 Hyer St_Sands_CC	111 Hyer St_Sands_CC

Please help me what DAX Formula to use. 

Thank you.

[Greg_Deckler · Accepted solution]

@juhoneyighot Well, if they are all in that format then something like this:

DAX Column = 
    RIGHT([Name], LEN([Name]) - 4)

[juhoneyighot]

Thank you