Published on September 02, 2021 at 11:39PM
if `try otherwise` not remembered then read this or else just `IFERROR`
Published on September 02, 2021 at 11:11PM
I call this function `ISPRESENT` to test for values that are not null, empty strings/blanks or zeros.
Published on September 02, 2021 at 11:09AM
You have a parameter like `today` and you want to easily add and substrate days from that... like yesterday is `days_ago(1)`
Published on September 02, 2021 at 11:00AM
Slap in that 1+1 = 2 blank function template so you don't have to do all the syntaxes
Published on July 29, 2021 at 06:10AM
Today is the 29th of July 2021... this Power Query M returns 1st of June 2021 like `1/06/2021`
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.
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
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
Published on August 19, 2020 at 01:10AM
Convert SAP Product Hierarchy that has been broken by Excel `1010101` back into `01010101`
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**
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 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 February 07, 2018 at 12:01AM
Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.
Published on February 05, 2018 at 04:50AM
Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query
Published on December 14, 2017 at 06:23AM
Just copy and paste this into a blank query and you will get a simple two column table with two rows.
Published on December 08, 2017 at 12:10AM
I regularly add a model to my Power BI or Power Query to represent the date and functions around date.
Published on June 21, 2017 at 12:51AM
Informally Known As WTF is M
Published on May 17, 2017 at 12:39AM
Very simple query to show when you last hit the 'Refresh' button in PowerBI
Published on March 23, 2017 at 06:16AM
I was sick of using Atom for Power Query without auto completion or syntax highlighting so I'm building an Atom Grammar package for M
Published on March 22, 2017 at 11:35PM
Investigating why Power Query is using so much RAM and CPU and what I can do about this
Published on March 20, 2017 at 12:33AM
A collection of the issues I run into day to day using the Query Editor along with the magic sauce to make it better
Published on March 06, 2017 at 06:18AM
Limit the amount of time you watch Power BI getting rows of data when you are working on your views
Published on March 01, 2017 at 12:54AM
Backing up and using version control systems are real things we should consider to save us from that next crash that is likely to occur
Published on February 21, 2017 at 01:18AM
Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID
Published on February 15, 2017 at 04:08AM
Reuse your code by pulling queries from web servers
Published on February 13, 2017 at 11:01AM
Just a simple reminder on how to do single and multiple line comments
Published on February 13, 2017 at 10:57AM
You know how to countif in Excel so why is Power Query so difficult?