Manually change value in a row of a Measured column

[saksham_kumar]

I have 4 columns - Category, Col A, Col B and Col C. Column C is a measured column (A+B).

3 rows are there. Category has

ABC in 1st row

XYZ in 2nd row

MNO in 3rd row

Col A has - 

1 in 1st row

4 in 2nd row

7 in 3rd row

Col B has - 

6 in 1st row

4 in 2nd row

9 in 3rd row

Col C has - 

7 in 1st row

8 in 2nd row

16 in 3rd row

Category	Col A	Col B	Col C
ABC	1	6	7
XYZ	4	4	8
MNO	7	9	16

Kindly imagine / visualize the above data as a table, could not paste (not sure sure if pasted correctly)

Now can I manually change the value 8 in Col C (which is against Category XYZ) to may be 10, 11 or whatever?

The other 2 values remain as it is. 

How can I do this. Thanks in advance for your help.

[v-yuta-msft · Accepted solution]

@saksham_kumar ,

You can modify calculate column as below:

Col C = IF('Table'[Category] = "XYZ", 10, 'Table'[Col A] + 'Table'[Col B])

 

Community Support Team _ Jimmy Tao

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

[saksham_kumar]

This is awesome! Thanks a ton