Power query lists

[dicken]

Hi,
I would like to to get a list of the values of a column repeated for every row of the table ;

so I would like to add a custom column and for every row have a full list of all the sales values,
using { [Sales] } just returns each value, I want to do this as I wondered if it would be possible to use list.select rather than table.select in creating a running total.
I'm sure I've been able to do this but can't remember how. If it's not possible please let me know and I can stop trying.


Richard

 

[JGordon11]

=Table.AddColumn(PrevStepName, "SalesList", each PrevStepName[Sales])

 

[dicken]

=Table.AddColumn(PrevStepName, "SalesList", each PrevStepName[Sales])

Thank you , I knew I should know how to do it,

RD