Written by Jay Killeen
Published on June 08, 2018 at 09:13AM
Because the current Excel Autosave is just so bad XD
Published on March 22, 2018 at 04:37PM
Turn on Agent Forwarding for SSH when deploying by Capistrano to Digital Ocean servers
Published on March 21, 2018 at 12:09PM
Take the currently logged in user in PowerBI and filter data based on an attribute of the User table
Published on March 09, 2018 at 09:07AM
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 04:07PM
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 10: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 10: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.
Published on February 05, 2018 at 02:50PM
Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query
Published on January 23, 2018 at 11:42AM
Convert a date to the Financial Year (Fiscal Year) like '01/01/2017' = '2018'. Australian example used. Pure VBA without Excel formulas. Just the solution.
Published on December 14, 2017 at 04:23PM
Just copy and paste this into a blank query and you will get a simple two column table with two rows.