Tag: Monthly Average

Calculate Average Sales In Power BI

Calculate Average Sales In Power BI

In this tutorial, you’ll learn how to calculate average sales in Power BI. You’ll learn and understand the logic of some tools and iterating functions inside your visualizations. Formula patterns will be shown for you to utilize and practice to improve your data development skills. You can watch the full video of this tutorial at

Continue reading

Calculate A Year-To-Date (YTD) Monthly Moving Average In Power BI

This is a deep dive tutorial on how to calculate the Year-To-Date Cumulative and Monthly Moving Average in Power BI. You may watch the full video of this tutorial at the bottom of this blog. The example used in this tutorial is from a question in the Enterprise DNA Support Forum. Aside from working out

Continue reading

Cumulative Totals Based On Monthly Average Results In Power BI

Today, I wanted to cover a unique technique around cumulative totals based on monthly average results in Power BI. You may watch the full video of this tutorial at the bottom of this blog. To set the date range for the calculation of monthly average results, we will be using a date slicer. A Power

Continue reading

Analyzing Average Results Per Month Using DAX In Power BI

In this tutorial, I go through an average results analysis technique. I dive into some types of procurement & purchasing analysis that you can do with Power BI. You may watch the full video of this tutorial at the bottom of this blog. Specifically, we’re going to look at the average monthly purchases a business

Continue reading