Forum Discussion
Create Custom Column based on specific combinations of values from another column
Hello, How can a new Task Status column be created based on the table and criteria below: Task Region Country Task Status NEW DESIRED COLUMN 1 EMEA Finland Complete In Progress 1 E...
= Table.Group(Source,{"Task","Region"},{"Task Status",each let a=List.Distinct([Task Status]) in if a{1}?=null then a{0} else "In Progress"})
Hey, you can group by task column first, then use conditional column to have a new column "task status".