The first few rows

How to take the first few rows from a table? How do we make this a parameter that we can change? This feature can be useful when we simply want to retrieve the first few rows from a table, or when it contains e.g. some sales data, we can sort them in descending order by the column that contains the sales value, and then we extract  the Top 5 items.

Keep or discard?

If you have used Power Query, you know that it has options that allow you to keep or discard certain columns. If you’re an Excel user coming through a Microsoft 365 subscription, there are a few new functions available to you to do a similar thing. As a result they create a dynamic array with columns or rows extracted from a given matrix that are retained or discarded.