Changing values

[stefc_01]

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 in these columns so that, 

1=11

2=10

3=9

4=8

5=7

6=6

7=5

8=4

9=3

10=2

11=1

or a forumla that would give me

1x11 + the sum of the amount of times the number 1 appears in the 11 columns

2x10+ sum of ""
3x9+ sum of ""

Many Thanks,

S

[Vvelarde]

@stefc_01

In Edit Query you can replace the Values.

Select all your columns before.

[stefc_01]

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 · Accepted solution]

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