Forum Discussion
New column based on occurrence of string from another column
Hi all, I would like to create a new column in a table that will show me Master Document numbers for Project Copies. Example: Table "Document" Document Number Document Category 61-2...
slorin
Super User
Super UserHi
With Table.Group
= Table.Group(
YourSource,
{"Document Category", "Document Number"},
{{"Data", each _}},
GroupKind.Local,
(x,y) => if y[Document Category]="Master Document" then 1 else 0)
Then expand columns
Stéphane
