Use a Table Column as a List in a Validation List

Published on April 18, 2017 at 07:07AM

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 12: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 02:41AM

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 04:53AM

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 06:16AM

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

The Microsoft Mashup Evaluation Container is a CPU and RAM hog

Published on March 22, 2017 at 11:35PM

Investigating why Power Query is using so much RAM and CPU and what I can do about this

Tiny Tweaks Needed for the Power Query Editor

Published on March 20, 2017 at 12:33AM

A collection of the issues I run into day to day using the Query Editor along with the magic sauce to make it better

Implementing an Environment Parameter in Power BI to Improve Performance in Development

Published on March 06, 2017 at 06:18AM

Limit the amount of time you watch Power BI getting rows of data when you are working on your views

Managing Queries in PowerBI and Power Query using Git

Published on March 01, 2017 at 12:54AM

Backing up and using version control systems are real things we should consider to save us from that next crash that is likely to occur

Disable the touchscreen and touchpad on ASUS running Ubuntu 16.04

Published on February 24, 2017 at 03:41AM

Because I did this one then forgot HTF I did it and had to switch it back on again