Forum Discussion
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 ||".
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
1 Reply
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