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 […]
I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling this […]
This is not the first time I have shared this concept. In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some […]
Sitemap Home My Courses – Excelerator BI Register New Account – Excelerator BI Expert Power BI Consulting – Learn and Lead With Excelerator BI ? Remote Support for Power BI, Power Query & Power Pivot Learn Power BI from an Industry Expert – Excelerator BI Power BI Training – Sign […]
Demystifying DAX Online Training Level: Intermediate to Advanced DAX Are you ready to take your DAX skills to next level? This course is ideal for those who already know how to write DAX and are ready to take their DAX skills to the next level. You will learn how the […]
The December 2020 version of Power BI desktop has just been released, and it is undoubtably the most important release since the first version way back in 2015. The super feature that has been released is an update to composite models using direct query of online datasets. The implications of […]
I was delivering an advanced DAX class recently and was chatting with the bright students in the class about various topics. Through the discussions it occurred to me that it may be possible to create a compound join between 2 tables using a combination of the inactive relationship feature and […]
Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register and was completely overwhelmed by the response. There were a few questions that I didn’t […]
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 […]
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 […]
Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular. The technology is essentially the same across all of these products so I will generically refer to Power […]
Original Post : Matt Allington, 24 Apr 2018 Background Technically you don’t need calendar tables to use Power BI, but for most reports that go beyond a simple Excel spreadsheet analysis, Calendars are an essential component of a successful Semantic Model. There are many different approaches to creating and maintaining […]
Level: Beginners Power BI has evolved significantly since Matt’s original publication of this article in 2016. While the foundational concepts remain relevant, modern features and best practices offer more secure, scalable, and collaborative ways to share content. This updated guide reflects the latest capabilities and recommendations for sharing Power BI […]
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 when he wrote the blog post 5 common mistakes of self taught DAX students at PowerPivotPro.com. Since then Matt expanded his ideas with the original release […]
Today I’m going to share my solution to a question I found on the MrExcel forum. It’s an interesting problem. https://www.mrexcel.com/board/threads/power-query-to-determine-consecutive-and-non-consecutive-dates.1261496/ Let me briefly explain the problem. The Problem We have the following table, which contains the source data. Each row contains a unique ID (maybe a piece of equipment) […]
Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive. For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the […]
Level: Intermediate Why You May Want to use RLS Imagine you’ve just built a Power BI report filled with sensitive financial data. You want to start to share this data across the organisation but not everyone is allowed to see everything. The CFO should be allowed to see everything, but […]
As you may know, Microsoft has an MVP Programme where it acknowledges and rewards community leaders for their subject matter expertise and contribution to the community. There are many benefits of being an MVP including the recognition (leading to people understanding that you must be doing something right if Microsoft […]
In this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by talking about the […]
About the Book Power Pivot Alchemy – Patterns and Techniques for Excel was written by Rob Collie (best selling PowerPivot author of DAX Formulas) and Bill Jelen (aka Mr Excel). It is a natural follow on for anyone that has read Rob’s first book. Alchemy is a book that covers […]