Forum Discussion
Helper IHow to shape and aggregate values on a column
Hello, I have a column with TEXT DATA that represents production numbers.
The format is:
21/00001
21/00002
21/00003
.............
Sometimes the production order is splitted in two different orders and the DB returns a different code:
21/00002
21/00002_02
It's correct to keep the order splitted but for some report I also need to aggregate such orders.
I would like to create a new column where splitted orders have the same code so I could aggregate them. Therefore I would like to have two columns:
ORIGINALE COLUMN
21/00002
21/00002_02
NEW COLUMN
21/00002
21/00002
Do you have any suggestion?
caseski , In power query you should split into columns based on _
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
1 Reply
- amitchandak
Super User
caseski , In power query you should split into columns based on _
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/