Power Query “each”
I am learning Power Query and the “each” function comes up a lot. Here is an explanation of its function …
Category Archives: Excel
Power Query Refer to previous row
There is an excellent tutorial from Goodly here. TLDR; use the list index selector {}
Power Query SumIF
Yesterday I wrote about how to calculate a running total (cumulative total) using Power Query. This used List.FirstN and the …
Creating running totals in Power Query
Power Query brings the power of ETL (extract, transform and load) tools to Excel. Almost every job I have now …
How to add a row number to an Excel table 2020 using Power Query Editor
Back in 2013 I wrote post on how to add a row number to an Excel table. This post is …
Power Query: How to load only fresh rows and create an Excel history table
I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 …
Next steps in Excel ETL – learning M
Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create …
Excel ETL – import multiple CSV files
I have previous blogged on how to unpivot data using Excel and Excel 365 (was Excel 2016) just keeps getting …
Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present …
Create the Union of two tables in Excel revisited
In 2013 I published a technique to create the union of two tables in Excel. This post is still very …
Dr James Bayley 