Whilst I was creating data to use for my training and blogs on Power Query, I spent time manipulating my data in a Microsoft Access database. It is however possible to do much of this transforming in Power Query and today I will look at a simple example.

Today I look at combining data from tables in Excel worksheets in other workbooks (again), with less steps thanks to the recent Combining Files improvements.

Grouping in Power Query is not intended to replace the excellent tools available in Excel spreadsheets to group and summarise data. Power Query’s talent is its ability to manipulate very large data sets, and it can be useful to group data before uploading to an Excel spreadsheet so that there are less rows to deal with...

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.