How to Create a Moving SUM with Visual Calculations and RANGE

Показать описание

In this tutorial, you'll learn how to use Power BI Visual Calculations to create a moving sum that updates automatically as you add new data. This technique is useful for analyzing trends and patterns in financial data, sales figures, or any other data set that changes over time. We'll start by creating a range that includes the data we want to analyze, and then use the SUMX function with a moving range reference to calculate the moving sum.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
#PragmaticWorks #powerbi #dax

00:00 Misconception about Moving Sum in Power BI
03:15 Creating a Moving Sum Calculation
04:53 Demonstrating the Moving Sum Calculation