Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help

Hi,

 

2019-03-01-PID 004-327-659 - 12851 Bathgate Way, Richmond.pdf

 

I have a column of unstructured data as mentioned above, and i was wondering if there is a way to create a new column and only display the data in red.  All the rows have the words "PID" in them.

 

thanks,

Need Help
  • yelsherif's avatar
    yelsherif
    7 years ago

    The error happens if Name2 does not contain "PID"
    So we can modify the formula to return blank if the search value is not found

     

    pidcolumn =

    var leftPosition = FIND("PID",Table1[Name2],1,0)
    return
       if(leftPosition>0,mid(theText,leftPosition,15),blank())

5 Replies

  • yelsherif's avatar
    yelsherif
    Resolver IV
    7 years ago

    The format of required part is PID nnn-nnn-nnn
    If this is always the case, then you can add a calculated column with the following formula
    newColumn =

    var leftPosition = FIND("PID",[sourceColumn])
    return
    mid(theText,leftPosition,15)
    • yelsherif's avatar
      yelsherif
      Resolver IV
      7 years ago

      Correction..

      newColumn =

      var leftPosition = FIND("PID",[sourceColumn])
      return
      mid([sourceColumn],leftPosition,15)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        it didn't work.  

        yelsherif wrote:

        Correction..

        newColumn =

        var leftPosition = FIND("PID",[sourceColumn])
        return
        mid([sourceColumn],leftPosition,15)
        yelsherif wrote:

        Correction..

        newColumn =

        var leftPosition = FIND("PID",[sourceColumn])
        return
        mid([sourceColumn],leftPosition,15)
        yelsherif wrote:

        Correction..

        newColumn =

        var leftPosition = FIND("PID",[sourceColumn])
        return
        mid([sourceColumn],leftPosition,15)