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
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
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
