Posts


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'

Create an Empty Table with Explicit Types in Power Query M

Published on June 09, 2020 at 09:32AM

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 03:55AM

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

Formula for Username in Excel

Published on April 27, 2020 at 12:44AM

You want a formula to return the the username of the current user working on the excel file.

A Simple Worksheet Parameter Pattern for Power Query

Published on February 26, 2020 at 04:17AM

How cool would it be to call a value from an Excel Worksheet from within a Power Query using a simple variable definition?

Cross Join in Power Query to Combine Two Tables with Every Combination

Published on September 13, 2019 at 04:06AM

When you want 'red,green' and '1,2' to become 'red1,red2,green1,green2' use a cross join!!

Debugging Postgresl and Rails PG::ConnectionBad: could not connect to server: Connection refused

Published on December 20, 2018 at 12:01PM

WHY??? It's your home! Go to your home!!

Things I Always Get Wrong When Programming

Published on December 18, 2018 at 11:03PM

Maybe if I write down the things I continuously do wrong then it will help me to fix them for next time XD