Forum Discussion
Trying to create new column by combining a string + column value
Hi,
I am trying to create a new column by adding "String123 - " to the beginning of the value from another column.
Hi Anonymous ,
This seems really tricky because PBI tries to apply the code in a query straight from the data source and depending on the data source itself, it either works or doesn't. I'd suggest you fix that column in the source or you create a view to manipulate the string. Another solution could be to you just use Import mode 🙂 Here a pretty lively discussion about your last error message:
OLE DB or ODBC error: [Expression.Error] We couldn... - Microsoft Power BI Community
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
9 Replies
- tackytechtom
Most Valuable Professional
Hi Anonymous
Here a solution in Power Query:
Here the code
= "String123 - " & [Column]
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ - tackytechtom
Hi Anonymous ,
And here a solution in DAX:
Right click on the column and press new column. Here the DAX:
Custom = "String123 - " & 'Table'[Column]
Generally, it is better to do such things in Power Query if possible, but since you posted it in here (Desktop), I wasn't sure which one you needed.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/I tried this DAX:
new_column ="String123 - " & 'table_name'[column_name]
And got this error:
"A single value for column 'column_name' in table 'table_name' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
- tackytechtom
Hi Anonymous,
I have not worked with Direct Query yet, so I tried to read up on it. It seems like it kinda depends on your data source, when you are using Power Query. Have you tried creating the new column in DAX? Does it return the same error message?
This seems a great resource that many other threads were referring to:
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Solved: M for Calculated Column in Direct Query Mode - Microsoft Power BI Community
DirectQuery in Analysis Services 2016 - SQLBI
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/