Published on July 27, 2021 at 03:02AM
Whenever you open a CSV file in Excel and it has a text field with numbers, and that text starts with a zero, then Excel will drop the zero.
Published on May 24, 2021 at 03:57AM
You want to send raw sql from Power Query to your SQL Server database so you can do better query folding than Excel.
Published on March 04, 2021 at 01:03AM
Adding a custom formula to a Salesforce Report to calculated Days Ago on User Last Login Date
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