Forum Discussion
Question on Replace Function
Hi,
I add a new column by copying an existing one and changing the format from numbers to text (copied year column and division new one) then add my text as shown so that i can create a relationship with another sheet.
I'm wondering if I refresh the original source data and new rows are introduced...will power bi automatically add the text that i entered in the new column.
//NT
Anonymous Put comma inside a double quotation and use & like below:
Date.ToText([Invoice Date]) & " , " & [Comments]Hope this answered your question. If, please mark it as a solution!!
14 Replies
Anonymous , In Power BI, when you create a new column by copying an existing one and then manually add text to it, the new column will not automatically update with the text you entered if new rows are introduced upon refreshing the original source data. This is because the manual text entries are not part of the data transformation logic and are not dynamically applied to new data.
To handle this you can use Custom column and try to all modifications on the basis of that
Anonymous As I can understand, that you want to create a key column to develop relationship with other tables. Yes, If you create a column based on other columns, as you mentioned, and add specific text, after refresh, the new column will automatically update whenever new data is added to the source file.
If this answered you question, please mark it as solution.Anonymous Please find the image below to create custom column. If your column is integer data type, then you need to convert it to text first to add custom text, otherwise it will throw error.
Number.ToText() function helps to convert numbert to text and '&' is used as concat text.If this solves your problem, mark it as solution.
Can you explain what is your exact requirement as compared to your original column
my requirement is establish a relation with another sheet so by adding a new column without using custom just by copying any existing one and changing the field from number to text
the above requirement is satisfied. but my question since i haven't used custom column only copy an existing one and made the changes...will the new column automatically introduced the changes i maded in this case a text after a refresh and numerous rows are created
hope i make myself clear
Select the column you want to copy.
Right-click on the column header and select Duplicate Column. This will create a new column with the same values as the original.Select OrderID_Text.
Go to the Transform tab.
Click on Data Type and select TextWhen steps are recorded in Query editor than new data will also be updated you can follow this method
