Posts


Excel FILTER FUNCTION contains text

Published on November 29, 2022 at 07:00AM

Don't even visit my website just copy this LOL -> `ISNUMBER(SEARCH("Special Sales Job", sales[project_name])`

[SOLVED] How to pass options for ChartJS plugin using Chartkick in Ruby on Rails

Published on April 22, 2022 at 05:48AM

Correct syntax for that chartjs plugins using chartkick in Rails

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`