Written by Jay Killeen
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.
Published on November 15, 2017 at 02:57AM
You have been using something like Git Bash and now switch to MSYS2 but want to use your old .bashrc like before
Published on October 29, 2017 at 11:58PM
You want a column to be called 'id' instead of 'TableID' because you don't have access to the database to rename the field directly