In this DAX tutorial, we’ll discuss context and its significance to understanding how DAX calculation engine works in Power BI. The idea of contexts in Power BI isn’t easy and it’s often overlooked. However, we need to remember that we always need to include the concept of context into our minds, especially when dealing with
Enterpise DNA Learning Summit is now rebranded and will be called Enterprise DNA Business Intelligence Summit. We’ll have this free quarterly event again this November and we’re expecting a large turnout and have some exciting sessions planned. Already we now have close to 1000 Power BI users registered to join. There will be plenty of
I’m going to show you how to create custom tiebreakers when using RANKX in Power BI. Getting a tie in a critical portion of RANKX results is a common scenario. There are a number of tiebreakers you can use but it’s important to choose the one that makes the most sense for each situation. The
In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits I’m going to start by creating a new measure and renaming it as Total Costs.
In this guide, I’ll briefly discuss how to use Quick Measures in Power BI. Quick Measures allows you to create DAX measures using a point-and-click method. Additionally, it enables you to quickly explore a lot of different formulas and formula combinations. Before I dive in, I just want to say that I don’t personally use