How to Create a Moving SUM with Visual Calculations and RANGE
In this tutorial, you'll learn how to create a moving sum using Power BI Visual Calculations. This technique is useful for analyzing trends in changing data sets. Start by creating a range that includes the data you want to analyze. Then, use the SUMX function with a moving range reference to calculate the moving sum. The video also addresses common misconceptions about moving sums in Power BI. If you're interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products, you can visit the provided link for a discount. The video also includes timestamps for specific steps in the tutorial.
Video 10m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time