Forum Discussion

oysteina's avatar
oysteina
New Member
4 years ago
Solved

Split String with other field data as delimiter

Hi, I'm new to Power BI, and has been tasked to move our reports from Qlikview. I've come across an issue I'm not successful in Googeling the answer to. In our database, the information of Vehicle M...
  • johnt75's avatar
    johnt75
    4 years ago

    You can do this in Power Query. Insert a step like

    = Table.AddColumn( #"Changed Type", "Maintenance ID", each Text.Replace( [Maintenance], [Vehicle],"") )

    and then you can delete the original Maintenance column if you don't need it for anything else 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You can do this in Power Query. Insert a step like

= Table.AddColumn( #"Changed Type", "Maintenance ID", each Text.Replace( [Maintenance], [Vehicle],"") )

and then you can delete the original Maintenance column if you don't need it for anything else 

  • oysteina's avatar
    oysteina
    New Member
    4 years ago

    Hi,

    Thanks for the reply!

    I will try this solution now. 🙂

     

    Br,

    Øystein