Forum Discussion

edday's avatar
edday
Regular Visitor
8 years ago
Solved

Splitting Columns without overriding

hello,

 

Is there a way to split columns in Power BI (using delimiters) without overriding the original column? I want to retain the column that holds the original data, but copy and split its data into separate columns as well. 

 

thanks,

 

edday. 

  • In the Query Editor you can first duplicate the column (tab Add Column) and split one of the two columns.

1 Reply

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion

    In the Query Editor you can first duplicate the column (tab Add Column) and split one of the two columns.