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.
Published on February 05, 2018 at 04:50AM
Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query
Published on January 23, 2018 at 01: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 06:23AM
Just copy and paste this into a blank query and you will get a simple two column table with two rows.
Published on December 08, 2017 at 12:10AM
I regularly add a model to my Power BI or Power Query to represent the date and functions around date.