Insert Text anywhere in a cell without adding a new column in Power Bi (Public)


Tue Oct 05 2021 02:28:55 GMT+0000 (UTC)

Saved by @cnewnham #vba

= Table.TransformColumns(#"Changed Type", {{"Audit Url", each Text.Insert(_, 0, “”), type text}})

Insert step after = Table.TransformColumns(#"previous power query named step", {{"column name", each Text.Insert(_, <number of characters in you want the text in the next section to inserted, e.g. 2 would mean it would be added 2 characters in>, “Text to add in”), type text}})