Forum Discussion
skopcak
Helper I
Helper IPower query editor - Adding text and columns in one step
I need to add a new column to merge
In Excel would be a formula
= CONCATENATE ("Example:"; A2)
Result:
| Data 1 | Result 1 |
| Text1 | Example: Text1 |
| Text2 | Example: Text2 |
| Text3 | Example: Text3 |
How to describe the formula in the power query editor?
thank you answer
= [Column1] & [Column2]
You need to escape the text like in Excel like this:
"Example"&[Data 1]
3 Replies
- Greg_Deckler
Community Champion
= [Column1] & [Column2]
- ImkeF
You need to escape the text like in Excel like this:
"Example"&[Data 1]
v-chuncz-msftCommunity Support