Tag: Monthly Average

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. The example used in this tutorial is from a question in the Enterprise DNA Support Forum. Aside from working out the Moving Average, we also wanted to show the results in a table with a

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. To set the date range for the calculation of monthly average results, we will be using a date slicer. A Power BI slicer is an alternative for filtering which narrows the portion of the dataset shown in

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. Specifically, we’re going to look at the average monthly purchases a business may make. I go through which DAX formula combination you need to be able to

Continue reading