Stumbling Around
Programming the Things

Written by Jay Killeen

Rails CSS Bundling for Tailwind Yarn package.json build:css command

Published on January 11, 2022 at 01:35AM

css:build for package.json for tailwind css in rails 7

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.