Please note javascript is required for full website functionality.



Power Query: Excel(lent) functions

5 April 2017

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.

Monday Morning Mulling – March 2017

3 April 2017

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

Final Friday Fix – March 2017

31 March 2017

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!

Power Query: One Route to a Running Total

29 March 2017

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.

A to Z of Excel Functions: the CEILING Function

27 March 2017

Have you reached your CEILING?

If I use VBA Then I get better at it!

24 March 2017

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

Power Query: Taking (Away) Steps for Efficiency

22 March 2017

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.

A to Z of Excel Functions: the CALL Function

20 March 2017

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

A to Z of Excel Functions: the BITXOR Function

17 March 2017

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

Power Query: M-Body Personified

15 March 2017

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