Stumbling Around
Programming the Things


Written by Jay Killeen


Add Text to an Existing Column in Power Query

Published on November 16, 2020 at 02:10PM

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 11: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 11: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 11: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 19, 2020 at 09:59AM

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 11: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 07:36PM

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 07:35PM

You have a string like '000123456' and you want to remove the zeros and make it '123456'

Create an Empty Table with Explicit Types in Power Query M

Published on June 09, 2020 at 07:32PM

Who'd a thought Explicit Types in an Empty Table would be so fulfilling... :/

[SOLVED] Today's Date in Power Query M

Published on June 04, 2020 at 01:55PM

Just copy `Date.From(DateTime.LocalNow())` <= this if you don't even want to visit my website XD