Table range

[Advanzer]

Hi everyone,

I need to create an interval table in power query from two parameters. 

The first is the number of intervals (Rows)

The second is the length of each interval. (Min and max)

The result should be:

Where

Desired Interval: 5 (Rows)

Interval width: (Max(Id)-Min(Id)) / Desired Interval

Id	Min	Max
1	1	21
2	21	41
3	41	61
4	61	81
5	81	101

Is there any idea ?

Thanks,

Regards Raul

[Greg_Deckler]

What does your source data look like or is what you are showing what the source data looks like? I'm not quite clear. If what you are showing is the source, what do you expect the output to look like?