Generate a list of values from number from different range

[laui]

Hi Folks,

I have a list that coming from numbers from different ranges, and then conver that list to a table. I guess I should look for List.Generate in Power Query but I struggle to do so. Any help is appreciated!

 List of values

Isaac

[v-yuezhe-msft · Accepted solution]

@laui,

Add a custom column using the code below and check if you can get expected result. If it doesn't help, please post your desired result.

=List.Numbers([From],[To]-[From]+1)

Regards,
Lydia

[ArquimedesP]

How Can I do it whit Dax in a calculated column?

[Anonymous]

@v-yuezhe-msft  this was SUPER helpful! Thanks! 

[laui]

Thanks you it works!