Power Query “each”
I am learning Power Query and the “each” function comes up a lot. Here is an explanation of its function …
Author Archives: Dr James Bayley
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 Orwellian
The premise of George Orwell’s 1984 was that history was continually rewritten to meet the needs of the current elite. …
Fixed: Microsoft Teams Meeting button missing in Outlook Desktop
My daughter’s lap is 5 years old and started misbehaving. I advised her to “reset” it and do a clean …
An educational video for British people under 30
It made me smile.
The London Mayor’s Solar Together “Scam”
Solar Together is a group buying project that helps householders purchase solar panels for their roofs. It is actually a …
Android users – you must use an SMS backup app
As a CTO and system admin I know that the three most important tasks are, Make sure that backups are …
This board game was played for 2000 years
One of the most interesting aspects of this game is the use of 4 tetrahedral “dice”. Unlike knucklebones that were …
Dr James Bayley 