Stumbling Around
Programming the Things

Written by Jay Killeen

Excel IFERROR in Power Query M or Power BI

Published on September 02, 2021 at 11:39PM

if `try otherwise` not remembered then read this or else just `IFERROR`

[SOLVED] Excel ISNULL, ISBLANK type custom function in Power Query M

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.

Power Query M function to add days to a date

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)`

Power Query M Blank Function Template

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

[SOLVED] Resync Postgresql tables primary key

Published on August 20, 2021 at 05:37AM

ERROR: duplicate key value violates unique constraint

Tail log files in Windows

Published on August 20, 2021 at 05:17AM

Unix is like `tail -f log.txt` and windows is like *chick chick boom*

[SOLVED] First Day of Last Month in Power Query M

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`

Left Pad a Number with a Zero if the Length is Odd in Excel

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.

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

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.

Salesforce Calculated the number of Days since last User Login

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