Introduction to DirectQuery-Level: Intermediate to Advanced Matt here. I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me. Parker has shared a few techniques with me that I found very interesting. These topics have not been covered on my blog before and hence I thought it was a […]Read More
Show Me All Invoices Containing this Product-Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here. I have modified the scenario a bit for this article and have built out some test measures to help explain some concepts. Problem Definition […]Read More
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 […]Read More
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 […]Read More
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 […]Read More
Cumulative Running Total Based on Highest Value-Level: Advanced I’ve helped a couple of people out on various forums on this topic over the last week, and that is normally a good sign that I need a blog post on the topic. The scenario is to create a Pareto cumulative running total based on the top products, customers or whatever. This is a bit […]Read More
Many to Many Relationships in DAX Explained-Level: Advanced (Level: Advanced, but explained in detail so everyone can understand) There is a lot to learn in DAX if you want to be a ninja. A couple of the more complex and important things to learn and understand are filter propagation and context transition. It is not so much that you need to be […]Read More
Bring your data to life - Let's discuss how Matt can help!