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.
For this tutorial, I’ll be showing you how to combine multiple DAX patterns in Power BI. This strategy is one of the many applications of measure branching and is an effective way of producing high-quality reports. When your goal is to analyze trends over time, sticking to basic formulas may not always give you valuable
In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few
Measure Branching is a technique in making calculations in Power BI. It’s not something you’ll hear often because it is unique to Enterprise DNA. It’s a methodology that I made to create measures out of measures. Calculating The Total Costs Using The RELATED Function I’m going to use the example of creating a calculation on
Once you start creating measures in Power BI, it’s necessary to learn how to organize everything. Creating measure groups is one of the best ways to make sure everything is in its proper place. Measure groups are like folders where you put similar measures together. They help make the entire process seamless, regardless if you’re
