Tag: CALCULATE function

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

Dynamically Calculate A Power BI Running Total Or Cumulative Total

The Power BI running total is the perfect way to display patterns and changes on a specified data over time. In Power BI, there is a common combination of DAX functions that allow us to create a dynamic cumulative total on any report page. The DAX formula that we’re about to discuss is easy to

Continue reading

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The difference between ALL and ALLSELECTED DAX functions can be relatively confusing when you’re starting out with Power BI. In this tutorial, I’ll quickly go over the main differences between those two commonly used DAX functions and their respective usages in your Power BI reports. Let’s take a look at this example. I’ll use this

Continue reading

Create Dynamic CRM Forecast From Today Until End Of Month

Calculate Total CRM Forecasts From Today Until End Of Month

In this tutorial, I’m going to show you how to create a dynamic total CRM forecast within a specified date range. Let’s say for example, you want to find out the forecast in a particular month. You want to know how many forecasts there are for the rest of the month from today until the

Continue reading

Pareto Analysis: Who Are The Top 20% Customers

Hey everyone, have I got an interesting insight for you! In this article, I’m going to go over the Pareto analysis and help you identify your top 20% customers. Not only do we want to break out the top 20% versus the bottom 80%, we also want to delve deeper into that top 20% and

Continue reading