Written by Jay Killeen
Published on October 11, 2018 at 12:18PM
You need validation lists to change based on selections... like a cascading validation list
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
Published on March 08, 2018 at 11:07PM
Users logged into PowerBI can have their email address exposed. This allows us to create dynamic row level security using inner joins on a user table.
Published on February 07, 2018 at 06:07AM
Now you can click a metric in one of your Worksheet reports and be taken straight to the underlying data in a way that is easy to see.
Published on February 07, 2018 at 12:21AM
This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query
Published on February 07, 2018 at 12:01AM
Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.