Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
3 years ago
Solved

Insert VALUES in all rows in a column in POWER Query

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 ||".     
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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