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.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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'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