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