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 […]
In the Supercharge Power BI Online Week 6 Review videos, you will learn the usage of multiple data tables and Cube formulas. You will learn how to connect multiple data tables to common lookup tables to create a mutual pivot table.
You will learn about cube formulas and how to write them from scratch.
You will learn to create cube formulas based on the data model in 3 different ways – in Excel Power Pivot, using Analyze with Excel from Power BI.com and connecting Excel to Power BI Desktop data model.
This is the last week of the Supercharge Power BI course and it is important to continue the practice of writing DAX and several useful links for the related sources are given at the end of this lesson.
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 […]
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 […]
In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections. In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery […]
Over the last few months, I have received a number of very similar questions at either one of our Live Training courses or from a student attending one of our Ask Anything Power BI Q&A sessions. These questions all revolved around DirectQuery and were often specifically about performance issues or […]
Excelerator BI | © 2023 | Sitemap