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