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

PHOTO EMBED

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

Saved by @Darkleech #vba

= Table.TransformColumns(#"Changed Type", {{"Audit Url", each Text.Insert(_, 0, “https://app.solv.com.au/#/app/safety/eventdashboard/”), type text}})
content_copyCOPY

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

https://www.youtube.com/watch?v=uVr-VjBWS6M