Forum Discussion

Babinsky's avatar
Babinsky
Icon for Helper I rankHelper I
9 years ago
Solved

Adding a new value in an Existing field

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 =...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Babinsky

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

     

Babinsky's avatar
Babinsky
Icon for Helper I rankHelper I
9 years ago

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's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Babinsky

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

 

  • Babinsky's avatar
    Babinsky
    Icon for Helper I rankHelper I
    9 years ago

    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