Conditional Column - repeat step

[Anonymous]

Hi,

I suspect this is a simple thing and I am just overlooking it so appologies in advance 🙂

Anyway, I have a conditional column which works great, I would like to do tha same condition to 25 identical columns (poor data source!). 

Can I process this same step on all the columns at the same time? Or copy step to the other columns easily?

Cheers,

Scott

[jgordon11]

If you want to add multiple columns use List.Accumulate

If you want to transform multiple columns use Table.TransformColumns

[Anonymous]

Cool, thank you. I will watch a couple of vidoes on that fuction later 🙂