Forum Discussion

Alirezam's avatar
Alirezam
Helper V
6 years ago

Replacing multiple valuse in Query

Hi mates, I have 2 tables. I want to replace one column's values with the second table. According to the photo attached, I want to replace 1 with a, 2 with b, 3 with c, so on. I know I can do it wi...
Need Help
danextian's avatar
danextian
Super User
6 years ago

Hi Alirezam ,

 

Try this in Power Query:

 

let 
//this will select the value from a list based on position where 1 is position 0
x = {"a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k"}
in  x{[Halfhour]-1}

 

or if the list is from another table

let 
//this will convert the values of the column holding the replacement values to a list. Make sure that the values are in the desired order.
x = AnotherTable[ColumnName] 
in  
//this will select the value from a list based on position where 1 is position 0
x{[Halfhour]-1}