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/
