In this tutorial, we work through how you can calculate the year to date moving average of results in Power BI using DAX.
It is common to show the absolute YTD numbers but not the average YTD numbers, so it was a good opportunity to jump into the unique calculation and show you how it can be done.
Good Luck
Sam
***** Video Details *****
2:09 - calculating monthly moving average
3:52 - monthly average vs YTD monthly average
5:31 - YTD monthly average formula
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Online - enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX - blog.enterprisedna.co/learn-how-to-calculate-sales-financial-year-to-date/
Preventing Year To Date Results From Projecting Forward - blog.enterprisedna.co/preventing-year-to-date-results-from-projecting-forward/
Using Moving Averages To Show Trends In Power BI - blog.enterprisedna.co/showcasing-trends-using-moving-average-techniques-in-power-bi/
***** Related Course Modules *****
Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-calculations
Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations
Solving Analytical Scenarios W/ Power BI & DAX - portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
***** Related Support Forum Posts *****
Cumulative Year To Date & Monthly Average Year To Date - forum.enterprisedna.co/t/cumulative-year-to-date-monthly-average-year-to-date/2707
Showcase Cumulative YTD And Average Month YTD - forum.enterprisedna.co/t/showcase-cumulative-ytd-and-average-month-ytd/3061
Removing Context From SUMMARIZE - forum.enterprisedna.co/t/removing-context-from-summarize/4674
For more YTD monthly average support queries to review see here…. - forum.enterprisedna.co/search?q=YTD%20monthly%20average
- Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX ( Download)
- Calculate Average Per Day / Month / Year In Power BI Using DAX ( Download)
- How to Calculate Moving Averages in Power BI - The Ultimate Guide ( Download)
- How to Calculate Year to Date, Month to Date (YTD, MTD) in PowerBI | MiTutorials ( Download)
- How to Do a YTD Calculation in Power BI ( Download)
- Calculate MOVING AVERAGES using DATESINPERIOD DAX Function // DAX Basics Guide in Power BI ( Download)
- Power BI - How to Calculate MTD (Month to Date) Rolling Total Values ( Download)
- Calculate a Rolling Average in Power BI Using DAX ( Download)
- Create Year-To-Date (YTD) measures in DAX ( Download)
- How to Calculate Moving Average in Power BI DAX ( Download)
- Computing rolling average in DAX ( Download)
- Calculating Sales Financial Year to Date in Power BI with DAX ( Download)
- Power BI Show Year-to-Date (YTD) Across Multiple Years ( Download)
- Monthly Average DAX - Power BI ( Download)
- How To Calculate Averages per Day in Power BI w/DAX ( Download)
