Forum Discussion
List.Numbers Within a Range
Hello, I'm trying to generate a list of numbers in my dataset within a range from 10-50 in an increment of 10. In other words, as it generates the number for each row, when it gets to 50, it shou...
Let's say you want to generate 18 numbers...Use below formula (replace 18 with the required number as per your need)
= List.Generate(()=>[x=10,i=1], each [i]<=18, each [i=[i]+1, x=if [x]=50 then 10 else [x]+10], each [x])