Written by Jay Killeen
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 August 20, 2021 at 05:37AM
ERROR: duplicate key value violates unique constraint
Published on August 20, 2021 at 05:17AM
Unix is like `tail -f log.txt` and windows is like *chick chick boom*
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 July 27, 2021 at 03:02AM
Whenever you open a CSV file in Excel and it has a text field with numbers, and that text starts with a zero, then Excel will drop the zero.
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 March 04, 2021 at 01:03AM
Adding a custom formula to a Salesforce Report to calculated Days Ago on User Last Login Date