Tag: Average Sales

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

Averages Per Customer Transactions – DAX in Power BI

What I want to demonstrate in this tutorial is how we can calculate the average amount of sales, profits, or transactions per certain dimension inside of DAX in Power BI. In this particular example we’re going to look at it from a customer’s perspective. We’re going to try and analyze what the average sales are

Continue reading

DAX Calculations: Total Of Average Results

This is a unique example of DAX calculations in Power BI. I will show you how you can calculate the total of a range of average results, utilizing the correct DAX formula combination. This requires a reasonable understanding of how iterating functions work within Power BI. These are functions like SUMX, AVERAGEX, MINX, MAXX. Usually

Continue reading