by Matt Allington | May 20, 2019 | Excelerator BI
Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart. Now I am not professing to be a Six Sigma black belt, but I do know how to write DAX and I do know how...
by Matt Allington | May 16, 2019 | Excelerator BI
I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. What is a Measure Table? A measure table is a dedicated table...
by Matt Allington | May 4, 2019 | Excelerator BI
I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a similar problem Fill Table with Last Survey Result using DAX here. The solution I am...
by Matt Allington | May 1, 2019 | Excelerator BI
Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Reid Havens a couple of months ago. I blogged about various other ways of...
by Matt Allington | Apr 22, 2019 | Excelerator BI
I have written a few articles in the past that toy with the ideas of changing visibility and text colour based on selection. I started to wonder if it was possible to make a visual appear (or not) based on a selection from the user. There is no out of the box way to...
by Matt Allington | Apr 18, 2019 | Excelerator BI
Just a short post today to share with you a permanent fix to something that has been annoying me (maybe you too – but then again I am easily annoyed 🙂 ). Edit: read the comments below from Amir Netz from Microsoft where he explains why this change was made...
