Written by Jay Killeen
Published on March 03, 2021 at 04:07AM
Using `Profile.UserLicense.LicenseDefinitionKey` we can select users by license type
Published on January 29, 2021 at 01:12AM
Point this query to your database table and return all columns and schema meta data using Power Query in Excel
Published on November 16, 2020 at 04:10AM
Add some text or value to an existing column of values. Example like adding "ABC" to the start of all values in a [Name] column
Published on August 21, 2020 at 01:27AM
CONVERT_TZ() makes you happy to keep your server on UTC while you sit in Brisbane eating Yatala Pie
Published on August 19, 2020 at 01:10AM
Convert SAP Product Hierarchy that has been broken by Excel `1010101` back into `01010101`
Published on August 19, 2020 at 01:02AM
SAP Product Hierarchy 0101010101 maps to Level 1 **01**, Level 2 **0101**, Level 3 **010101** Level 4 **01010101** and Level 5 **01010101**
Published on August 18, 2020 at 11:59PM
Taking a Date (ie 1st July 2020) and converting it to Financial Period Key (ie 202001). Built for Australia style Financial Year
Published on June 15, 2020 at 01:23AM
You want to send raw sql from Power Query to your database because you're better at query folding than Excel.
Published on June 09, 2020 at 09:36AM
You probably extract data from SAP that looks like '000ABC1234' and you want to remove the '000'
Published on June 09, 2020 at 09:35AM
You have a string like '000123456' and you want to remove the zeros and make it '123456'