Tag: Measure Branching

Calculating Dynamic Profit Margins – Easy Power BI Analysis With DAX

Calculating Dynamic Profit Margins - Easy Power BI Analysis With DAX

I want to go over how to calculate dynamic profit margins in Power BI. This is something I consider to be quite straightforward if you’ve been using Power BI for some time. But if you’re just starting out, this could be challenging to piece together. This kind of information is something that most organizations need.

Continue reading

Why Using Power BI Variables Is A Better Way To Write DAX Measures

Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin Advice

Using variables is a great way to make sure that your results add up the way they should at the end of your measures. Variables are such a crucial part of writing and solving formulas inside Power BI and I’m going to show you why. Sample Data Visualized In Gantt Chart To showcase the importance

Continue reading

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Conditional formatting is a way of visualizing data by applying a certain set of format rules based on user-defined conditions. For Power BI visuals, it is mostly used when presenting data in a tabular form. In this tutorial, I’ll discuss how to combine DAX formulas with the new conditional formatting feature to highlight the last

Continue reading

Calculating Dynamic Percentage Of Total Change Using Power BI Time Intelligence

Calculating Dynamic % Of Total Change – Power BI Analysis With DAX

In this tutorial, I’ll show you a dynamic way of getting the Percent of Total Change in Power BI using simple measure branching techniques and time intelligence calculations in Power BI. For example, if you want to work out the difference in contribution of Sales for a particular dimension and its change from year to

Continue reading

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can

Continue reading