Forum Discussion
Helper IIIMultiply multiple columns at once based on list of columns
Table.TransformColumns( DataTypeAuto, List.Transform(caLst, (x) => {x, (w) as number => Number.From(w) * 10}) )Hi Goodkat
This is an interesting question and can be done by List.Accumulate using the following formula
= List.Accumulate({"2025 - 1", "2025 - 2"},DataTypeAuto,(a,b)=>
Table.TransformColumns(a,{b, each _ * 10, type number}))Please find your solved file in the attached and dor further details, se my video as bellow
https://www.youtube.com/watch?v=G8PRbWuDcmQ&t=98s&pp=ygUWb21pZGJpIGxpc3QuYWNjdW11bGF0ZQ%3D%3D
Super UserHi Goodkat
This is an interesting question and can be done by List.Accumulate using the following formula
= List.Accumulate({"2025 - 1", "2025 - 2"},DataTypeAuto,(a,b)=>
Table.TransformColumns(a,{b, each _ * 10, type number}))
Please find your solved file in the attached and dor further details, se my video as bellow
https://www.youtube.com/watch?v=G8PRbWuDcmQ&t=98s&pp=ygUWb21pZGJpIGxpc3QuYWNjdW11bGF0ZQ%3D%3D
Helper IIIDear Omid,
absolutely cool! Thankfully AlienSx and you provided cutting edge solutions. Short, precise & effective. I put your solution also into my knowledge base and I read now more about List.Accumulate to fully leverage this new PQ command from your proposal. It seems powerful.
Thank you & Best regards, Andreas