Require a whole number from List.Max() so that I can use it in List.Repeat() function

[Codemunchkin]

Hi, 

I am stuck with this 😞

I am trying to get a whole number value of max value of a column of a different table using List.Max(). This function returns a list but I want a number (such as Table.RowCount() function) so that I can put that in List.Repeat() function ideally I want to replace this formula --> List.Repeat(List.Numbers(1, 4),4) with List.Repeat(List.Numbers(1, List.Max()) ,Table.RowCount(#"SKU COUNT")).

[mahoneypat · Accepted solution]

Here is an example of the needed syntax to get a list.

= List.Repeat(List.Numbers(1, List.Max(NumberTable[NumberColumn])), Table.RowCount(NumberTable))

Pat

[Codemunchkin]

Thanks so much Pat!