Posts

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

Blank Power Query Template for a Raw SQL Query

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.

Removing Leading Zeros from Alphanumberic Strings using Power Query M

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'

Remove Leading Zeros from Strings using Power Query M

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'