Forum Discussion

stefc_01's avatar
stefc_01
Regular Visitor
9 years ago
Solved

Changing values

Hi!    I am very new to powerbi and hoping someone can help me with this...    I have 11 coloumns that have roughly 4000 rows containing a value between 1 and 11, how can i easily swap the values...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI stefc_01,

     

    Please take a look at below article which about multi condition replace, I think it is suitable for your requirement.

    Multi Condition Logic In Power Query

     

    Regards,

    Xiaoxin Sheng

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

stefc_01

 

In Edit Query you can replace the Values.

 

Select all your columns before.

  • stefc_01's avatar
    stefc_01
    Regular Visitor
    9 years ago

    Thanks for the reply, 

     

    That is i thought but how would you get past this problem..  if for example i change the original value of 4 to 8, how do i then change the original value of 8 to 4 without affecting the new value of 8 that i created ?

     

    Once i get past the number 6 i would start overwriting the new values. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      HI stefc_01,

       

      Please take a look at below article which about multi condition replace, I think it is suitable for your requirement.

      Multi Condition Logic In Power Query

       

      Regards,

      Xiaoxin Sheng