Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Get value before second delimiter in DAX

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

General Comment
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    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 )

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    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 )
    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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. 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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())