Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

This document explains the purpose, components, and usage of the Power Query M Standard Library Dashboard. It is designed to help beginners, developers, and data enthusiasts understand the structure ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

There’s a new M function in Power Query in Power BI that allows you to read the data from a Parquet file: Parquet.Metadata. It’s not documented yet and it’s currently marked as “intended for internal ...

There are times that you you want to use the Table.Skip Power Query function, but the number of rows you want to skip varies from file to file in your folder. You want the number of rows to be dynamic ...

If you’re writing your own M code in Power Query in Power BI or Excel you may run into the following error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue. If you’re a ...