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. You may watch the full video of this tutorial at the bottom of this blog. Rolling Averages can give you valuable insights into a variety of data, especially in Sales. This dashboard shows

Continue reading

Calculate Average Per Customer Transaction Using DAX In Power BI

What I want to demonstrate in this tutorial is how we can calculate average sales, profits, or transactions per certain dimension inside of DAX in Power BI. You may watch the full video of this tutorial at the bottom of this blog. In this particular example we’re going to look at it from a customer’s

Continue reading

DAX Calculations: Total Of Average Results

This is a very good demonstration 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. You may watch the full video of this tutorial at the bottom of this blog. This requires a reasonable understanding of

Continue reading