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 […]
Search Results for: many to many
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 […]
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 […]
On 12th April 2023, Iman and I hosted Miguel Myers as our special guest at the Sydney Power BI User Group. Miguel is a visualisation guru from Microsoft and has worked there for many years. He has recently been assigned as the Product Manager for Visualisations in Power BI, and […]
I do a lot of Power BI model and report development; maybe you do too. There’s nothing worse than spending an hour or so developing your model only to have something go wrong and you lose your work. Things that can go wrong include: Your PC/App crashes. Power BI does […]
Microsoft has just announced the general availability (GA) of the integration of Power BI with PowerPoint. I have previously blogged about this feature here => Power BI Live Embedding. With the recent GA announcement comes a significant improvement over the public preview version. Power BI Single Visual Embedding in PowerPoint […]
Early Bird & Group Booking Discounts ExceleratorBI offers various discount packages for our Microsoft Power Bi courses, including our early bird and group booking deals. Our early bird offer provides a 10% discount to students who book at least a month before the course start date. Group bookings discounts occur […]