Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Community
Please ask for your help with knowing how to write the formula in Power Query if I want to generate a new column with the one letter along with the value of a current column.
Example:
"S" [Center], where S is the letter and [Center] is the column of a current table.
Currently I enter it like this but it generates error.
Stay tuned
Saludso
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Pls refer the below:
If the column is number ,use the below to create a new column ,then delete before column and rename new column:
"S"&Number.ToText([Center1])
If the column is text,use the below to create a new column ,then delete before column and rename new column:
"S"&[Cebter2]
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @Syndicate_Admin ,
Pls refer the below:
If the column is number ,use the below to create a new column ,then delete before column and rename new column:
"S"&Number.ToText([Center1])
If the column is text,use the below to create a new column ,then delete before column and rename new column:
"S"&[Cebter2]
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I finally discovered the error.
To be able to create a concatenated column in PQ, it must only be text, IT CANNOT BE NUMBER
What I need is to join "S" & (Center)
But it gives me error as seen in the following image:
StepName = Table.TransformColumns( Source, { { "name", each Text.Combine({"ABC",(_)}), type text } } )
>>>REFER >>> Add Text to an Existing Column in Power Query | jaykilleen.com
Regards,
Ritesh
I still get an error "Eof token expected"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
79 | |
75 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |