Tag: DAX Combination

Advanced DAX Functions: Calculating Profit Contribution

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.

Continue reading

Combining DAX Patterns Or DAX Formulas In Power BI

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

Continue reading

How To Use Simple Filters In Power BI

In this article, I am going to give you an overview of simple filters in Power BI. We have already done a few examples regarding this so it should not be too difficult to pick up. I am doing these demonstrations in tables for a good reason. It is easier to understand how formulas work

Continue reading

DAX Measures In Power BI Using Measure Branching

Build DAX measures using measures. This is what I call measure branching. This technique is one of the most important development strategies that you need to learn. Measure branching in Power BI is about creating advanced measures within a measure itself. I always recommend that you start with simple DAX measures first so you can

Continue reading

Analyze Profit Margin Changes Overtime – Analytics with Power BI and DAX

In this blog post, I will show a really unique and specific example where I’m going to hone in on how you can combine lots of the techniques that I’ve described in many previous tutorials to come up with profit margin changes. These are techniques like Measure Branching, Trend Analysis, and DAX Formula Combinations. What

Continue reading