Written by Jay Killeen
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.
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'
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'
Published on June 09, 2020 at 09:32AM
Who'd a thought Explicit Types in an Empty Table would be so fulfilling... :/
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
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.
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?
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!!
Published on December 20, 2018 at 12:01PM
WHY??? It's your home! Go to your home!!
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