Get value before second delimiter in DAX

[jeongkim]

Hi,

How can we get value up to before second delimiter / in DAX creating new column? 

Hope the solution will not be with Left or Mid fucntion since there will be changes on number of text. 

Since it is dynamic and shouldn't depend on string length. 

Result will be:

PLMN-PLMN/MRBTS-113960

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

expected result CC = 
VAR _firstfind =
    FIND ( "/", data[id], 1 )
VAR _secondfind =
    FIND ( "/", data[id], _firstfind + 1 )
RETURN
    LEFT ( data[id], _secondfind - 1 )

[jeongkim]

Thanks,

Can you further help if there is other values not finding / delimiter? such (blank) and dn$.

I'm not sure what to be more in the future so Im trying to avoid specify these 2 other values in dax code. 

[jeongkim]

resolved. 

INVUNIT Key dn$ =

VAR _firstfind =

    FIND ( "/", 'CM Data - Equip Info'[INVUNIT $dn], 1 )

VAR _secondfind =

    FIND ( "/", 'CM Data - Equip Info'[INVUNIT $dn], _firstfind + 1 )

RETURN

    IF(CONTAINSSTRING('CM Data - Equip Info'[INVUNIT $dn], "/"), LEFT ( 'CM Data - Equip Info'[INVUNIT $dn], _secondfind - 1 ), BLANK())