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...
Understanding Context Transition can be super frustrating for a new Power BI user. Definitions for it seem deceptively simple, but wrapping your head around how it actually works within a DAX expression can be painfully difficult. Fear not though my fellow DAXciples,...
Gaining an understanding of Row and Filter Context is among the most difficult challenges facing a new DAX author. Just when you think you've got it, a problem arises and your hard-won mental model seems to crumble before your eye. For a...
Text.Trim() does an excellent job of getting rid of things like " leading spaces" and "trailing spaces " but unlike its' Excel cousin it doesn't handle "excess inner spaces" at all. Granted...
Line charts are the ideal way to show historical data when 'understanding the trend or path of a metric' is what your decision maker is after. Like most good visualizations they can be extremely data dense, showing lots of information in a...
If you're used to working in Excel you're quite familiar with the idea that there's about a dozen ways to do anything. In this video we look at yet another approach to creating a 4-4-5 fiscal calendar table from a summary table....
The art of visualization layout is a tricky one. Once you start throwing more than one or two charts onto a page it can start to turn into a tricky-to-navigate hodgepodge of lines and bars where it's hard to get a sense...
Relative Month and Year columns in calendar tables are indispensable. They let you create simple, easy to read time intelligence measures that don't require recoding at the end of each year/month to redefine what "this year/month" is. With them you can write...
(AKA "Pleased to Meet You, I Hope You Guess My CSVs Name.") This is based on a question that floated into my inbox this week. If you're combining a folder full of CSVs but you want to retain the name of the CSV...
Month label columns are invaluable for things like slicers and report axis. When users see 9 then don't immediately get that you're talking about September, but put a "Sep" on that slicer and things snap into focus pretty quick. But kinda like...
List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary, this is a very useful function that can get you out of...
