Blog

Measure Tables in Power 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 used to store some or all of the […]
Expanding Rows Using Power Query - 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 providing in this blog post is using […]
Grouping in Power BI Desktop Without Using DAX - 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 doing this, including banded columns using DAX […]
Show or Hide a Power BI Visual Based on Selection - 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 do […]
Reposition Report Canvas in Power BI Desktop - 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 Vertically Position Report Canvas in […]
Scale your Power BI Capacity Up/Down - This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs).  In my first article I explained the problem and the logic behind how to configure a workable solution. In my second article I provided step by step instructions on how to […]
Simple Filters and Syntax Sugar in DAX - Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use the DAX language.  Here are a couple of examples Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount]) Total Sales Full Syntax = […]
Affordable Power BI Premium for Small Business (Part 2) - Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordable for small to medium sized enterprises (SMEs).  You can read the first article in this series from the following link: Affordable […]
Affordable Power BI Premium for Small Business (Part 1) - Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually.  I have long been frustrated by the lack of a suitable scalable Power BI pricing model for small to medium sized enterprises (SMEs).  You can read my rant about that […]
Conditional Formatting with a Text Field in Power BI - One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI.  Last week, John asked me how to apply conditional formatting with a Text field (not a numeric field).  I knew it could be done, but […]
Find and Delete Duplicate Photos with Power Query - I was trying to clean up my hard disk drive on my PC the other day.  I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here).  After running the software I noticed that I had stored photos from […]
Calculation Groups are Coming to DAX - I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits.  Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris Webb and The Italians, but I wanted to give my […]
Query By Example YYYY-MM
Query by Example to Extract YYYY-MM from a Date Column - I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the Year into 1 column Extract the Month […]
What is the Best Training for Business Analysts? - Updated Feb 2019.  This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today.  The market is changing so quickly that many Business Analysts (BAs) are only just […]
Extract Numerical Data Points from an Image - Today Gartner released the 2019 magic quadrant for Business Intelligence.  As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision.  I thought it would be interesting to see a trend over time for the last 5 […]
Power BI Features Reporting
Power BI Features Reporting - Matt here.  The blog article this week was written by Neville de Sousa.  Neville shared with me a Power BI report that shows all the Power BI features released since July 2015.  Neville will explain the background and his report. Neville:  Keeping track of Power BI Desktop’s amazing features since it went GA is difficult, […]
calendar overrun in Power BI
Calendar Over Run While Comparing Last Year’s Data - Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share with others. The Problem I will illustrate the issue using the AdventureWorks database (I need to make some tweaks to do this).  […]
Copy measures between PBIX files
Copy Measures Between 2 Power BI Files - I have often been asked (and wondered myself) if it were possible to move all the measures from one Power BI PBIX file into another.  Imagine you have 2 PBIX files with similar data models (similar enough that the measures will be substantially the same).  It doesn’t matter how you got to this point – […]
Import First Sheet with Power Query
Import the First Sheet in a Workbook with Power Query - My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in a folder with Power Query. Load the Latest Version of a File with Power Query. Combine all sheets in a […]
A further (final?) update about Power Pivot - This is the longest running blog post series I have on my website.  Why does Power Pivot Crash so often and what can I do about it?  I have three previous articles that you can read in the links below Original post (Oct 16): Does the Power Pivot Excel Add In Crash for You? Follow […]