Update same value in duplicate rows

[Anonymous]

Hi,

I need urgent help. I am trying to create a calculated column to update the New status in the same Item code.

for example: 

For Item BE96X new status should be "Missing Drawing/ Sample"

For Item BN98E New status should be "Not Started"

Note: Status should be selected by me which I want to update.

Item	Status	New Status
BE96X	Missing Drawing/ Sample	Missing Drawing/ Sample
BE96X	In Progress	Missing Drawing/ Sample
BE96X	Complete	Missing Drawing/ Sample
BN98E	Missing Drawing/ Sample	Not Started
BN98E	Not Started	Not Started

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous 

According to your description, I am not particularly clear if you want the fixed values of “new status” like the screenshot you gave or want to update the new status by the status you selected.

The two solutions are as follows.

1, the fixed values of “new status” like the screenshot you gave

Create a column.

Column =
IF ( 'Table'[Item] = "BE96X", "Missing Drawing/Sample", "Not Started" )

Final output:

2, update the new status by the status you selected

Create a measure.

new status2 =
SELECTEDVALUE ( 'Table'[Status] )

 Put “Item”, “Status” into slicer, the New Status will be updated according to the status you selected.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.