Blog

Extract Table Size from Power BI Desktop Using DAX Studio - I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others.  I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version of DAX Studio can be […]
Conditional Formatting in Power BI - Level: Beginners I blogged on conditional formatting in Power BI Table visual here when it was released in the May 2016 Power BI Desktop update. At the time of first release, the conditional formatting was pretty basic with only 1 formatting option available. Over time, Microsoft has improved this feature, and now, it is available in both Table and […]
EARLIER vs EARLIEST in DAX - Level: Advanced The EARLIER() and EARLIEST() functions are 2 of the harder functions in DAX to get your head around. If you come from a programming background it will probably be easy for you.  However as I have repeatedly stated on my blog, one of the many great things about Power BI is that it […]
Sales of Same Products to Other Customers - Level: Intermediate I was helping someone on a forum recently and I thought the question and solution would make an interesting blog article. I have adapted the scenario to work with Adventure Works customer purchases, but this concept would work equally well across other entities, such as sales territories, calendar years etc. Problem Definition The […]
Lineage in DAX - Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles).  Today I thought I would write a single post dedicated to lineage. As you may know, Power BI has a number of different operation modes, some of which do not require the data to be […]
Q&A in Power BI Desktop - Regular readers of my blog probably get sick of hearing me rave about the latest new thing in Power BI.  This month there is an absolute cracker – Q&A in Power BI Desktop.  In case you don’t know, Q&A is a natural language query tool that allows you to ask a question about your data […]
Virtual Filters Using TREATAS - Level: Intermediate I have been aware of the TREATAS function for a very long time.  I have tried to understand how it works a few times but could never really work it out. I think part of the problem is the function name TREATAS is not very descriptive.  To contrast this point, the FILTER function […]
Line Chart Conditional Formatting - I’m really pleased and excited to introduce you to Daniil Maslyuk (Twitter: @DMaslyuk).  I first met Daniil about a year ago (originally via email) as he was preparing to move to Australia.  Daniil made the plunge shortly there after and migrated to Australia (from Russia) – he now works as a Power BI consultant for Agile BI here in […]
Pass an Excel Parameter to Power Query - Where has Matt been? Regular readers of my blog may have noticed I have been missing in action over the last month.  I have been super busy with the PUG World Tour, delivering a lot of training, finalising my new book Supercharge Power BI, and also taking a couple of weeks vacation. Side Story: Power […]
Killer Tips to Write Harder Measures - Level: Intermediate Background I was reading the questions at http://community.powerbi.com today and saw an interesting question.  In short the OP wanted to know if there was a way to identify (via a measure) if the row in a table had a colour =”Blue”, but also to check that there were no other rows with the […]
DAX UNICHAR Function in Power BI - I first learnt about the new DAX UNICHAR function in Power BI by reading Chris Webb’s blog (which was also the inspiration for this article today).  One of the uses of the UNICHAR function is to be able to include non text characters inside visuals.  When you combine a logical set of these codes (icon sets) you […]
Using Variables in DAX - Level: Intermediate The variable feature in DAX has been around for more than a year and I have simply never got around to writing an article about it – I am changing that today.  Let me start off with some version information and syntax and then I will show you are real life example where I […]
Power BI Accounting Format of Dollars - Level: Beginners As I often say, sometimes it is the little things that can make a big different for some people – in this case Accountants. I was teaching a Power BI class a few weeks ago and I was discussing how the number formatting options work in Power BI.  One of my students (Sheldon) […]
How To Solve a Complex DAX Problem - Level: Advanced I was helping someone on Power Pivot Forum last week with a tricky calculated column question.  As an aside, you may know that I always advise beginners to keep away from calculated columns.  You mostly don’t need calculated columns because in most circumstances a measure is a better option to use (read more […]
New Functions – GENERATESERIES, SELECTEDVALUE - Level: Beginners/Intermediate In the August 2017 update of Power BI Desktop Microsoft released the new What If feature (first demonstrated at MDIS in July).  This new What If capability uses two new DAX functions to complete a task that you have always been able to do manually.  You still can of course still do it […]
What is DAX - I have written a series of articles over the last few years including: What is Power Pivot What is Power Query What is Power BI But I have never written an article about the DAX language, so I thought I would cover this off today. What is DAX? DAX is an acronym for Data Analysis […]
Measure Dependencies in Power BI - Update:  Unfortunately after I released the latest version of my workbook in this article, something changed with Excel to stop the file working as designed.  At this stage I do not know what the issue is, but it seems to only affect the current channel versions of Excel.  I have just reinstalled the deferred channel […]
DMV to Extract Measures from Power Pivot - I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities.  These are both excellent tools in their own right and I encourage you to read up on those previous articles to learn more about these tools. Today however I am going […]
Happy Second Birthday Power BI - The 24th of July, 2017 is the second birthday for Power BI.  I thought I would take the occasion of its second birthday to reflect on all the great work that the crack Power BI team at Microsoft has done over the last year.   I think it would be a tough job working in […]
When to Use SUM() vs SUMX() - Level: Beginners/Intermediate It has been 2 years since I first wrote an article about SUM() vs SUMX().  I decided to write a new article to refresh this topic and add in the things I have learnt over the last 2 years. SUM() vs SUMX() First let me start with an overview of both of these […]

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x