Though this may sound similar to last week’s blog, in many ways this method has just as much in common with One Folder, One Query...

I begin in a workbook that contains three worksheets. Each of the worksheets has been populated with a table of expenses information...

As I described in Calendar Creation – Preparing for Dates building a calendar using Power Query is a collaboration between Excel and Power Query. Read this article to find out how!..

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

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.

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.

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.

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.

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

As a programmer, I was often asked to produce delimited versions of reports which could easily be picked up by Excel. Whilst it is possible to clean non-delimited files in Excel, it’s a laborious and repetitive process, which is why it made more sense to pay for a programmer to automate it.