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 […]
Search Results for: many to many
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 […]
Demystifying DAX Online Training (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 DAX […]
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 […]
Every now and then I write an off-topic blog post; today is one of those days. In the past I have shared how I manage my time, in case you are interested in going back and reading that one. Today I want to give you some motivation to save well […]
This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to […]
I am writing an off-topic article today but I promise I will circle back later in the week with a follow up article bringing it back on topic. In this article, I am going to share a COVID report I built today, and later in the week I will post […]
I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s […]
Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not […]
Power BI Consulting Expert Help When you Need it Most Let’s face it – no one has the time or the resources to become and expert in every skill needed to run a successful business. But of course you don’t have to be an expert at everything, as long as […]
Original Post: Feb 2017 Updated: May 2021 I first wrote this article back in Feb 2017 to be a definitive list of the top reasons you should consider using Power BI in your organisation (in case you haven’t already made the decision to do so). In fact there is only […]
Power BI Instructor Led Live Corporate Training You’ve come to the right place At Excelerator BI, we offer world-class instructor-led training to organisations large and small. The training can be live face-to-face, or instructor led live online or video on demand with online live Q&A calls. What's The Best Option […]
Power BI Corporate Training You’ve come to the right place At Excelerator BI, we offer world-class instructor-led training to organisations large and small. The training can be live face-to-face, or live remote and on-line. What's The Best Option For My Company? World Class Power BI Corporate Training for your Business […]
A client recently asked me if it was possible to build a Power BI report using data from a Microsoft Form. I have come across this question a few times now, and you could be excused for thinking this would be a straightforward task. Despite the fact that Microsoft has […]