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" Fo...
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.

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.