Published on April 05, 2017 at 04:53AM
Fixing bugs like "We cannot convert the value "[Table]" to type Table."
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
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
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
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
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
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
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
Published on February 23, 2017 at 07:21AM
Simply Count the
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