Tag: MAX function DAX Power BI

Calculating A Rolling Average In Power BI Using DAX

In this tutorial, I’m going to show you how to calculate a dynamic Rolling Average in Power BI using the ALLSELECTED function. Rolling Averages can give you valuable insights into a variety of data, especially in Sales. This dashboard shows how many sales are made per day and the amount of revenue earned. There’s a

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

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

Dynamically Calculating The Previous Highest Result Using DAX Functions

DAX functions greatly expand dynamic calculations. They also broaden the other important capabilities in Power BI.  In this tutorial, we’ll discuss how you can dynamically calculate the previous highest result in Power BI. We’ll also be learning the right combination of formula and techniques for this particular calculation. By doing a dynamic calculation, we can

Continue reading

Revenue Forecast Technique for Project Data – Power BI Insights With DAX

In this tutorial, I’m going to show you a real-world insight that enables you to utilize project or opportunities data to create a Revenue Forecast in Power BI. This technique is extremely relevant to CRM systems. This can also be used on your captured information like Sales and Projects, and also on potential revenue forecasts.

Continue reading