Forum Discussion

Newcolator's avatar
Newcolator
Icon for Helper II rankHelper II
3 years ago
Solved

Create a list of numbers using a variable

Hello   I need to create a table that contains the numbers 0 to n based on the number of months I have in my tables I can use = List.Numbers(0, 20)  to create my list   ,but I want the number ...
Need Help
  • Newcolator's avatar
    Newcolator
    3 years ago

    I think I have worked it out using = List.Numbers(0,List.Max(claims[ClosedDevMo])+1)

Newcolator's avatar
Newcolator
Icon for Helper II rankHelper II
3 years ago

Actually, change that slightly, forget about dates. I have a column in my containing the month number, I just need to create a table that goes from 0 to the max of that column value.