Insert VALUES in all rows in a column in POWER Query

[Andrew_na_lang]

HI PBI FAM,

I need help in adding values before  [DXB] -xxxxxxx to make the format of all rows in the column identical. 

I need to insert "Tray: XXX ||". 

 

[amitchandak · Accepted solution]

@Andrew_na_lang , We split bu Using Text.BeforeDelimiter and Text.AfterDelimiter and and then combine

= Text.BeforeDelimiter([Column], "-")  & "Tray: XXX ||" & Text.AfterDelimiter([Column], "-") 

Text Before Delimiter and Text After Delimiter: https://youtu.be/oGY4RoPKDOE