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
Tag: MAX function DAX Power BI
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
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
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
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.