Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Update same value in duplicate rows

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.

ItemStatusNew Status
BE96XMissing Drawing/ SampleMissing Drawing/ Sample
BE96XIn ProgressMissing Drawing/ Sample
BE96XCompleteMissing Drawing/ Sample
BN98EMissing Drawing/ SampleNot Started
BN98ENot StartedNot Started

 

Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    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.

1 Reply

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Community Support
    3 years ago

    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.