Posts


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

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

SumIFS in Power BI DAX Using Current Row Value as Filter

Published on February 23, 2017 at 07:22AM

Simply sum the quantity using a field from the current row as a filter in the table you are summing from

CountIF in PowerBI DAX

Published on February 23, 2017 at 07:21AM

Simply Count the

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