Recategorizing data in PowerBI Desktop

[lindagoos]

I am trying to recategorize a column so that the column updates from "Priority" to "New Priority".  Each row has a unique ID.  Based on that ID, I want to identify whether it should remain as a priority 1, change to priority 1-scorecard or change from Priority 2 to priority 1.  I will need to add about 115 unique IDs to be changed to 1-scorecard and just 1 unique ID to change from Priority 2 to Priority 1-scorecard.  My data also includes Priority 3 but those will remain the same. Any help is very much appreciated!

ID	Priority	New Priority
Abc-123	1	1-scorecard
Abc-456	1	1
ABC-789	1	1
DEF-123	1	1-scorecard
DEF-456	1	1-scorecard
DEF-789	1	1
GHI-123	2	1-scorecard
GHI-456	2	2

[camargos88]

@lindagoos ,

What logic do you need to apply ??

[lindagoos]

I basically need to say, if it contains any of the 115 unique Ids in column 1, then it is 1-scorecard.  If it contains another unique ID(s) in column 1, then it is 2-scorecard. If, it is any other of the unique IDs, the priority remains the same.