Forum Discussion
MagikJukas
3 years agoResolver III
Max value from each table
Hello, I would like to add a column to each table in the "Rows" column where it calculate the Max value from the Indexstart column. thanks
MagikJukas
3 years agoResolver III
Hello collinsg
thanks for your comment.
I notcied my problem description was not clear.
in the code below, you apply the Max number from the list.
#"Rows + Max Indexstart" = Table.AddColumn(
#"Added Max Indexstart col",
"Copy Rows and Add Max Indexstart",
each Table.AddColumn(
[Rows],
"Max Indexstart",
each List.Max(#"Added Max Indexstart col"[Max Indexstart])
)
),
Instead I want to add number from each line, to the new table.
For instance, I want the first table to contain a new column with 1, and the second table a column with 566.
your solution was pushing the max (566) both tables.
are you able to advise how to correct it? 
thanks