The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Insert text anywhere in a cell without adding a new column using the Power Query’s UI

There are no Insert functions ( that I know of) in the power query user interface, so if you don’t know M, you probably have to create a new column to insert text in power query.
In today’s video, I will show you how you can use power query user interface, to insert text into a column without adding a new column and using only one step.

*NOTE: this works for inserting text anywhere inside a record or value or cell.

Table of contents:

00:00 Intro & use case
00:35 Do it creating a new column
01:30 Do it again in one step

Watch the tutorial:

Insert text anywhere in a cell without adding a new column using the Power Query User Interface.
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents