cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sks2701
Helper II
Helper II

Group

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?

 

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

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 

SU18_powerbi_badge

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User II
Super User II

@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
Super User III
Super User III

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 

SU18_powerbi_badge

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors