Forum Discussion

nheller's avatar
nheller
New Member
8 years ago
Solved

Replace values in one column with a conditional referencing another column

I have two columns: 'Partner Name' and 'Client Name'. Each time a particular value in 'Partner Name' is referenced ('xyz'), I'd like to replace the corresponding null in 'Client Name' with a new value ('abc'). I'm new to Power BI and haven't quite picked up on M yet-- Can somebody help me out?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi nheller,

     

    You could create a new 'Client Name' column, then, remove the original one.

     

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi nheller,

     

    You could create a new 'Client Name' column, then, remove the original one.

     

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-yulgu-msft 

      What should be written under "Else" if I wish the values to remain the same, if the specified conditions above are not met?

       

      thank you!