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
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
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
Hi @OsceolaDelgado-6635
If by the greatest of chance the above proposal solved the issue would you mind accepting it as answer to help those who search before posting? Thanks & any question let me know
3 people are following this question.