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

Need Help

3 Replies

    • 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.