Forum Discussion
Sum total occurrences of each value in a string using Power Query
I assume that you have a column which contains unique values in the table e.g. OrderID, SellingID.... If not, add an Index column to the table first.
Select PseudoNo column, split it by delimiter into Rows.
Group by the Index column (or the unique key column) and PseudoNo column like below.
At last add a custom column to multiply two columns.
Sample file is attached at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello jennratten
So for each specific row, I have to also multiply the count of each part from the PseudoNo column with the shipping quantity of that row. For example the shipping qty column below with the PseudoNo column I have above:
Would result in the table for the highlighted rows:
| PartNums | Count | TotalQty |
| TS12 | 2 | 4 |
| TS12U2 | 2 | 4 |
| TS24IC10 | 1 | 2 |
So the method that you stated above would work if we also added another column like above to track the total qty as well.
Community Support
I assume that you have a column which contains unique values in the table e.g. OrderID, SellingID.... If not, add an Index column to the table first.
Select PseudoNo column, split it by delimiter into Rows.
Group by the Index column (or the unique key column) and PseudoNo column like below.
At last add a custom column to multiply two columns.
Sample file is attached at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.