Last week, we showed you how to declare variables. This week, we’re going to use a variable to create a loop. Let’s introduce the For loop.

Building a calendar using Power Query is a collaboration between Excel and Power Query...

This function sounds like something you calculate whilst swinging from the chandeliers...

One of the most useful things you can do in VBA is to store values in the program’s memory, so that you can use it in the future...

Over the last few weeks I have shown some of the tasks that can be achieved with M language and functions. Today I look at how to replicate some familiar Excel formulas.

Last week, we looked at a strange event – in certain cases when you are creating running totals, Power Query stores the number in strange ways....

In celebration of having published three full months of Power Query blog articles, we’re dedicating the March Final Friday Fix to a Power Query problem!

Welcome to our latest Power Query blog. Last time I looked at row level operators and simplifying bulky code. Today I combine two list functions to show one method to achieve a running total.

Have you reached your CEILING?

This function returns the cumulative interest paid (“cumulative interest payment”) on a loan between a designated start_period and end_period given a constant periodic discount rate...