Adding a new value in an Existing field

[Babinsky]

Hi All,  I have a question:

 I have 2 fields

Code - which contains - 6980

Cause - which contains -  ABC

 I'm looking to use Advanced Editor to populate the field Cause with value ZWR if Code = 6980

Thanks!

 - Babinsky

[Greg_Deckler]

There's probably some fancy M for that, but brute force, create a new conditional column,

= if [Code] = 6980 then "ZWR" else [Cause]

Remove your original Cause column and rename this column to Cause and done.

[Babinsky]

Hi Smoupre, for your suggestion below would this be a New Measure, New Column?

= if [Code] = 6980 then "ZWR" else [Cause]

Thanks!

- Babinsky

[Eric_Zhang · Accepted solution]

@Babinsky

I think @Greg_Deckler refers to add a "custom column" in "Query editor" window "add Column" tab.

[Babinsky]

Thanks v-lvzhan-msft.  That solution worked, sorry for the late reply as I was working on other assignments.

Have a great day everyone!

- Babinsky

[LaurentCouartou]

Also, you can use the Add Conditional Column feature for that kind of calculations.