BRIAN GRANT (CSG Pro) In this presentation local DAX obsessive Brian Grant will show you how to use a CSG built Dial sparkline measure to quickly display goal to actual information in a highly compressed manner that will be an excellent addition to...
If the goal is an actual comparison, it's hard to beat the bullet chart. Highly efficient in terms of the amount of space they take up, with excellent data to ink ratio, they are both immediately intuitive yet data-dense without relying on...
Sparklines and small multiples are incredibly powerful. They allow you to add a tiny simple graph to a table or a matric that conveys the basic idea or shape of the data in a way that is compact enough to allow for...
Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look at rollup values it's difficult to be confident that you're getting the...
A generally best practice in Power BI is to avoid naming columns in ways that won't make sense to users so things like CustomerFirstName should be broken out with spaces between the words. The problem is that when faced with a big...
Getting a percent of total measure working in DAX, understanding how it's working in a non vague way can be quite a bit trickier. Really it is an ideal pattern to learn some of the underlying behavior of DAX. In this video, we...
When learning DAX, time intelligence formulas are an excellent place to start, and of the many formula patterns out there, “Year to Date” variations might be the best to learn first. The problem is, while writing them is fairly easy, understanding how...
I have been fully immersed in the healthcare industry for the past six years, having finished my masters in health care management at Johns Hopkins Carey Business School and working in roles from physician scribing to health insurance operations. The common denominator...
I chose a career in consulting because I love solving problems, am dedicated to continual learning, and have a passion for teaching. I was first introduced to consulting in graduate school and immediately knew this was my calling. I was enticed to...
Custom columns are often the lifeblood of any M queries that you build. They give you huge amounts of power but by default remain untyped. You could add a step to type each new column after you create it, or even type...
You've built a simple "Sum for All Categories" measure that is so darn simple that it's impossible for it not to work; but alas it does not. If the category column you were trying to remove from the filter context had a...
If you've got a large number of columns on a table to transform it can be quite a hassle. Here we'll show a way to use List. Transform along with some code fishing techniques to whip up a solution to convert a...