Get value after delimiter in dax

[Anonymous]

Hi,

I only need number in the end.

e.g. 002

pls not hoping using Right/Left function since values have sometime 3 digits or 4 digits dynamically. 

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can use formula like 

Number_After_Underscore =

VAR TextValue = 'Table'[PO#]

VAR UnderscorePosition = SEARCH("_", TextValue, 1, LEN(TextValue))

RETURN

    MID(TextValue, UnderscorePosition + 1, LEN(TextValue))

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[MohamedFowzan1 · Accepted solution]

Hi @Anonymous 

Sample Table:

You could do this by finding the position of the "_"

NumberSuffix = 
VAR text1 = Pos[Pos]
VAR pos = SEARCH("_", text1, , -1)    
RETURN
    MID(text1, pos + 1, LEN(text1) - pos)

Sample Output:

If Resolved, Mark as Solution to guide Others!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can use formula like 

Number_After_Underscore =

VAR TextValue = 'Table'[PO#]

VAR UnderscorePosition = SEARCH("_", TextValue, 1, LEN(TextValue))

RETURN

    MID(TextValue, UnderscorePosition + 1, LEN(TextValue))

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly