Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to Solution.
= [Column1] & [Column2]
You need to escape the text like in Excel like this:
"Example"&[Data 1]
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
You could also use Text.Insert.
Text.Insert([Data 1], 0, "Example: ")
You could also use Text.Insert.
Text.Insert([Data 1], 0, "Example: ")
You need to escape the text like in Excel like this:
"Example"&[Data 1]
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
= [Column1] & [Column2]
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.