Forum Discussion

6DiegoDiego9's avatar
6DiegoDiego9
Helper I
4 years ago
Solved

Scroll to the 800000th row in Power Query Editor

The following M line is (wrongly) not cutting any row at the end of my source with about 800000 rows:  = Table.FirstN(#"Trimma il ""1"" finale dalle instestazioni",each List.NonNullCount(Record.ToLi...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    1. Go to Transform tab - Reverse Rows

    This will put your last rows on top and you can do the analysis.

    After your analysis is over, then delete the Reverse Rows step.

     

    2. Another way is issue this statement

    =Table.LastN(#"Your previous step",10)

    10 means that it will display your last 10 rows. You can replace 10 with whatever no.

     

    3. Another way is insert an Index column. Then you can filter on this Index. 

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

1. Go to Transform tab - Reverse Rows

This will put your last rows on top and you can do the analysis.

After your analysis is over, then delete the Reverse Rows step.

 

2. Another way is issue this statement

=Table.LastN(#"Your previous step",10)

10 means that it will display your last 10 rows. You can replace 10 with whatever no.

 

3. Another way is insert an Index column. Then you can filter on this Index.