Stumbling Around
Programming the Things

Written by Jay Killeen

Center Aligned Pagination in Rails using Bootstrap 4 and Kiminari

Published on June 14, 2017 at 10:21AM

Pagination looks nice when it is centered below a table. Here is how I got it to work.

Excel Actually Sucks

Published on May 18, 2017 at 01:23PM

Just a place where I can write all the things I hate about Excel. Remember to just breathe

Simple Power Query M to Display When the Report was Last Refreshed

Published on May 17, 2017 at 10:39AM

Very simple query to show when you last hit the 'Refresh' button in PowerBI

VBA for Last Saved At Timestamp with Hours Minutes and Seconds Ago

Published on May 04, 2017 at 04:50PM

Useful to have as a button or invoke overtime to alert when you have forgotten to save

Display a SQL Server Table Schema in PowerBI

Published on May 03, 2017 at 02:33PM

This was useful when building a subsequent M Query and needed to know all available table column, types and keys

Use a Table Column as a List in a Validation List

Published on April 18, 2017 at 05:07PM

This is easy to do but not as easy as you would first think.

Cheatsheet for DAX date and time functions

Published on April 07, 2017 at 10:40AM

Commonly used functions I use for DAX date and time functions including Count of Days in Current Year,

Cheatsheet for Running SQL Against PostgreSQL from the Command Line

Published on April 06, 2017 at 12:41PM

I am using psql to interact with a PostgreSQL database from the command line and I don't know what I am doing :P

Turning On Fast Combine in Power BI to enable Personal Gateway Data Refresh

Published on April 05, 2017 at 02:53PM

Fixing bugs like "We cannot convert the value "[Table]" to type Table."

Creating an Atom Grammar Language Package for M Power Query Formula Language

Published on March 23, 2017 at 04:16PM

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