Power Query: new column value = list

[gheyman]

I want to add a new column to an existing table in power query. I need the value of that column equal a list that i created in power query named "Curve". How do I do this? Thanks for the help.

 

[JGordon11]

An example

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Curve = List.Transform({1..Table.RowCount(Source)}, each Number.Power(_,2)),
    cols = Table.ToColumns(Source) & {Curve}, 
    headers = Table.ColumnNames(Source) & {"Curve (Parabola)"},
    Result = Table.FromColumns(cols, headers)
in
    Result

Book1
	A	B	C	D	E	F	G
1	Column1	Column2		Column1	Column2	Curve (Parabola)
2	A	col2 item1		A	col2 item1	1
3	B	col2 item2		B	col2 item2	4
4	C	col2 item3		C	col2 item3	9
5	D	col2 item4		D	col2 item4	16
6	E	col2 item5		E	col2 item5	25
7	F	col2 item6		F	col2 item6	36
8	G	col2 item7		G	col2 item7	49
9
Sheet1

 

[gheyman]

Thanks. My list "Curve" only has one column and one row (value). My list was a table table I that I transformed into a list in Power Query. There should only be one value in it. But I want to populate an entire column/field in another table with that value from the list (same value for all rows). Will this work for that? (sorry will be away from that spreadsheet so I will not be able to try your solution for another couple of hours. Thanks for the Help

 

[gheyman]

Thanks. My list "Curve" only has one column and one row (one value). My list was a table table I that I transformed into a list in Power Query.

I have an existing table named "Material_Distribution_Output" I want to add a new column to this table that will contain the value from the list named "Curve". (The same value in every row of the Material_Distribution_Output table).

Will this work for this? Sorry I will be away from this spreadsheet for several hours so I will not be able to try your solution until much later.

Thank you for your help. Very much appreciated.

 

[JGordon11]

Do you want the the entire Curve list in each row of the new table? If not, I am not following what you are trying to do. If you can provide an example of the table, the list, and how the final table should look it should make things clearer.

 

[gheyman]

I got it.

I create transformed the table into a List in Power Query Editor. I then created a new column in my desired table. The formula I put in the table was "=Curve()"

Appreciate the help.