Power Query Column Replace Help

Question

I want to replace 2 column in same step of power query . Let suppose I have 1-3 in one column and 2-3 is second column . with single step I want to multiply each value with 2 and replace it with new value

Thanks

Answer 1

Hi @Osceola Delgado

Assuming I understood, one way:

let  
// Table for demo.  
    Source = Table.FromColumns(  
        { {1..5}, {6..10}, {"a".."e"} },  
        type table [NumOne=number, NumTwo=number, Aplha=text]  
    ),  
//  
    ReplacedNum = List.Accumulate({"NumOne","NumTwo"}, Source,  
        (state,current)=>  
            Table.TransformColumns(state,  
                {current, each _ *2, type number}  
            )  
    )  
in  
    ReplacedNum