Stumbling Around
Programming the Things


Written by Jay Killeen


Add a DateKey Column in PowerBI M Lang

Published on February 21, 2017 at 01:18AM

Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID

How I setup my ~/.gitconfig

Published on February 16, 2017 at 04:21AM

Because it is such an important part of my git workflow and I always forget

Boilerplate Excel VBA Functions module

Published on February 15, 2017 at 05:59AM

A basic module I load to each project for shared functionality

Loading M Queries from the Web into Power BI

Published on February 15, 2017 at 04:08AM

Reuse your code by pulling queries from web servers

Add a Simple Wiki to your Rails App

Published on February 13, 2017 at 11:12AM

I added a wiki to one of my sites. This may inspire you to create one yourself.

How I Setup my ~/.bashrc

Published on February 13, 2017 at 11:08AM

Because it is such an important part of my workflow and I always forget

Create Rails App with Hashicorp Otto on Windows 10

Published on February 13, 2017 at 11:03AM

Dabbling in Hashicorp Otto trying to create a simple Rails environment

Single and Multi Line Comments in Power Query Advanced Editor

Published on February 13, 2017 at 11:01AM

Just a simple reminder on how to do single and multiple line comments

Countif in Power Query or Powerbi using M Language

Published on February 13, 2017 at 10:57AM

You know how to countif in Excel so why is Power Query so difficult?

Get Row Number in Worksheet in Excel Using VBA

Published on February 13, 2017 at 10:54AM

A simple function to return the row number of a table where a value is matched in a column. Like a VLOOKUP or INDEX MATCH for VBA.