The ever-vigilant folks on the internet have spotted that there’s a new M function in the latest versions of Power BI and Excel: Module.Versions.This function, at the time of writing, returns a record ...

Have you heard of Power Query in Microsoft Excel but always thought that it's only intended for Excel experts? Let me stop ...

When I first saw Data Explorer (as Power Query used to be called), I immediately started thinking of it as a self-service ETL tool; indeed, it’s how Microsoft itself is positioning it.However I ...

Data Analysis Expressions is a formula language used by Power Pivot in Excel and by Power BI. In essence, it’s how you write formulas for calculations in the aforementioned applications: the ...

Compared to Excel formulas, Power Query is more efficient, automates processes, reduces errors, and simplifies complex operations, making it a superior tool for handling data workflows.

Creating custom columns in Power Query can involve complex formulas and calculations. To simplify the process and enhance the readability of your queries, you can use the `let` keyword.

The formula bar in the Power Query Editor updates automatically with the M code corresponding to the applied data manipulation step. The M code can seem intimidating at first, but you can easily ...

In this post, we will show you how to reorder multiple columns in Power Query with Drag & Drop. ... When you reorder the columns in Power Query, a Table.ReorderColumns function will be created.