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...

At the end of that article, I had made some changes to a query of mine, ‘ACCT_Order_Charges_with_Group’. I will be making more changes, but to avoid causing problems to the grouping query, I will create a copy of the query.

This week, we’re going to cover the use of the IF statement in VBA. This is a very useful tool to help apply conditional rules in macros...

Welcome to our latest Power Query blog. Last time we looked at M language syntax in a simple query. Today I add some code to operate on each row in a table and show how bulky code can be simplified.

Look, before we go anywhere here, this function is for advanced users only. If you use the CALL function incorrectly, you might be looking for a new computer – well at best, you’ll have to restart your PC....

This function returns a bitwise ‘XOR’ of two numbers (XOR was first introduced in Excel 2013 and at the current rate of publishing these articles we should get to this one by 2044)...

In order to see some M language in action, I return once again to the query I created in Two (Queries) Become One.

It’s time to find thee antidote to the recent BITLSHIFT function and you shouldn’t feel bitter (BITR?).