Group

[sks2701]

I have a data base that has different stage of ideas, I want to group these by creating a new column (Overall Idea status ) with the below values

Idea Review = Idea Review

Idea Feasibility= In progress

Solution development= In progress

Solution deployment = In progress

Business Impact Validation= In progress

Stakeholder Sign off= In progress

Closed = Closed

Dropped Idea = Dropped

Please can you suggest how can we do this?

ID	Final
1	Idea Feasibility
2	Idea Feasibility
3	Idea Feasibility
4	Idea Review
5	Idea Feasibility
6	Idea Feasibility
7	Idea Feasibility
8	Idea Review
9	Idea Feasibility
10	Idea Feasibility
11	Idea Feasibility
12	Idea Feasibility
13	Idea Feasibility
14	Idea Review
15	Stakeholder Sign off
16	Business Impact Validation
17	Idea Feasibility
18	Solution Development
19	Idea Feasibility
20	Idea Review
21	Dropped Idea
22	Idea Feasibility
23	Idea Feasibility
24	Idea Feasibility
25	Closed
26	Idea Feasibility
27	Idea Feasibility
28	Idea Feasibility
29	Idea Feasibility
30	Idea Feasibility
31	Idea Feasibility
32	Idea Feasibility
33	Idea Review
34	Idea Feasibility
35	Idea Review
36	Idea Feasibility
37	Idea Feasibility
38	Idea Feasibility
39	Idea Feasibility
40	Idea Review
41	Idea Feasibility
42	Idea Feasibility
43	Idea Feasibility
44	Idea Feasibility
45	Idea Feasibility
46	Idea Review
47	Idea Review
48	Idea Feasibility
49	Closed
50	Idea Feasibility
51	Idea Feasibility
52	Idea Review
53	Solution Development
54	Idea Feasibility
55	Idea Feasibility
56	Solution Development
57	Idea Review
58	Idea Review
59	Solution Development
60	Idea Feasibility
61	Idea Feasibility
62	Idea Review
63	Idea Review
64	Idea Review
65	Idea Review
66	Idea Feasibility
67	Idea Feasibility
68	Idea Review
69	Idea Review
70	Idea Feasibility
71	Closed
72	Idea Review
73	Idea Review
74	Idea Feasibility
75	Idea Review
76	Idea Feasibility
77	Dropped Idea
78	Idea Feasibility
79	Idea Feasibility
80	Dropped Idea
81	Closed
82	Idea Review
83	Idea Review
84	Idea Feasibility
85	Idea Review
86	Idea Review
87	Solution Deployment

[wdx223_Daniel]

@sks2701 

= Table.AddColumn(Source,"Overall Idea status",each {null,"Idea Review","In progress","Closed","Dropped"}{List.PositionOf({{"Idea Review"},{"Idea Feasibility","Solution Development","Solution Deployment","Business Impact Validation","Stakeholder Sign off"},{"Closed","Dropped Idea"}},[Final],0,(x,y)=>List.Contains(x,y))+1})

[AlB · Accepted solution]

Hi @sks2701 

Just add a custom column with this code:

= if List.Contains({"Idea Feasibility", "Solution deployment", "Business Impact Validation", "Stakeholder Sign off"}, [Final])
then "In progress"
else  if [Final] = "Dropped Idea" then "Dropped" else [Final]

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers