Written by Jay Killeen
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?
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!!
Published on December 20, 2018 at 12:01PM
WHY??? It's your home! Go to your home!!
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
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.
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!
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.
Published on June 07, 2018 at 11:13PM
Because the current Excel Autosave is just so bad XD
Published on March 22, 2018 at 06:37AM
Turn on Agent Forwarding for SSH when deploying by Capistrano to Digital Ocean servers
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