Posts

Left Pad a Number with a Zero if the Length is Odd in Excel

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.

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

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.

Salesforce Calculated the number of Days since last User Login

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

Count User Logins This Week by License Type in Salesforce

Published on March 03, 2021 at 04:07AM

Using `Profile.UserLicense.LicenseDefinitionKey` we can select users by license type

Return Database Schema for Table Using Power Query

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

Add Text to an Existing Column in Power Query

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

MySQL Convert Datetime field in UTC Timezone to Brisbane Australia

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

Power Query - Left Pad an SAP Product Hierarchy with Zero

Published on August 19, 2020 at 01:10AM

Convert SAP Product Hierarchy that has been broken by Excel `1010101` back into `01010101`

Extract Multiple Product Hierarchy Levels from an SAP Product Hierarchy Key

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**

Using SQL to Convert Date to Financial Period Key

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