Stumbling Around
Programming the Things

Written by Jay Killeen

A Simple Worksheet Parameter Pattern for Power Query

Published on February 26, 2020 at 04:17AM

How cool would it be to call a value from an Excel Worksheet from within a Power Query using a simple variable definition?

Cross Join in Power Query to Combine Two Tables with Every Combination

Published on September 13, 2019 at 04:06AM

When you want 'red,green' and '1,2' to become 'red1,red2,green1,green2' use a cross join!!

Debugging Postgresl and Rails PG::ConnectionBad: could not connect to server: Connection refused

Published on December 20, 2018 at 12:01PM

WHY??? It's your home! Go to your home!!

Things I Always Get Wrong When Programming

Published on December 18, 2018 at 11:03PM

Maybe if I write down the things I continuously do wrong then it will help me to fix them for next time XD

An Elegant Way to Clear the Excel VBA Immediate Window When Debugging

Published on October 17, 2018 at 04:45AM

Your Immediate Window is so jammed with debug.print that you just want to clean slate it... quickly... and elegantly... like a gazelle.

Edit Data Validation Lists in Excel using Arrow Keys

Published on October 11, 2018 at 06:16AM

You are trying to edit a Data Validation List and when you click the arrow keys things turn crazy and annoy you sooooo bad!

[SOLVED] Fix Duplicate Conditional Formatting Rules in Excel 2016

Published on September 18, 2018 at 04:48AM

You have conditional formatting rules in Excel 2016 and all of a sudden they are duplicated all over the place and super messy. This fixes it.

Building Your Own (And Better) Autosave Feature for Excel

Published on June 07, 2018 at 11:13PM

Because the current Excel Autosave is just so bad XD

Again With The Permission Denied Could Not Read From Remote Repository

Published on March 22, 2018 at 06:37AM

Turn on Agent Forwarding for SSH when deploying by Capistrano to Digital Ocean servers

Add Dynamic Role Level Security to PowerBI Using an Attribute of the Current User

Published on March 21, 2018 at 02:09AM

Take the currently logged in user in PowerBI and filter data based on an attribute of the User table