Using the List.Range function, you can get specified values from some column. 

For example in this table, you may need three animals, starting from the second animal:

The function is:

  • = List.Range(


  • = List.Range(
       Source[Animal], – name of previous step and name of column with values we need
       1, – where to start. Attention, Power Query counts from zero. So Hamster is 0, Guinea pig is 1, etc. So number 1 means we are starting from the second item.  
       3) – we need 3 animals

After extraction we have this:

It can be used for running totals, getting values from previous rows etc.

Leave a Reply

Your email address will not be published.


clear formPost comment