Average, Moving Average at Different Granularity - DAX or Excel Formulas

Average, Moving Average at Different Granularity - DAX or Excel Formulas

ExcelIsFun via YouTube Direct link

) Basic DAX Calculation: Total Profit and Average Profit using the SUM Function and the AVERAGE Function

4 of 15

4 of 15

) Basic DAX Calculation: Total Profit and Average Profit using the SUM Function and the AVERAGE Function

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Average, Moving Average at Different Granularity - DAX or Excel Formulas

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) What is Granularity?
  3. 3 ) Look at Data Model and Hide Columns from Client Tool
  4. 4 ) Basic DAX Calculation: Total Profit and Average Profit using the SUM Function and the AVERAGE Function
  5. 5 ) Start PivotTable with DAX Transactional Average for each month. Granularity: Transactional.
  6. 6 ) Excel Spreadsheet formula to calculate Transactional Average for each month using AVERAGEIFS function. Granularity: Transactional.
  7. 7 ) Discuss Filter Context and how it works in the Power Pivot Data Model
  8. 8 ) DAX Formula for Transactional Moving Ave Profit Last 90 Days using CALCULATE and DATESINPERIOD. Granularity: Transactional.
  9. 9 ) Excel Spreadsheet formula to calculate Transactional Moving Ave Profit Last 90 Days using AVERAGEIFS function. Granularity: Transactional.
  10. 10 ) Create Line Chart to plot Month Average and 90 Day Moving Average
  11. 11 ) DAX Formula to calculate Daily Average Profit. Granularity: Daily. See the AVERAGEX Function and the Measure for Total Profit perform a calculation due to Filter Context and Row Context. Discussion…
  12. 12 ) Excel Array Formula to calculate Daily Average Profit. Granularity: Daily. See the functions: AVERAGE, SUMIFS, ROW and INDIRECT. See how to generate (materialize) an entire table of valid dates in …
  13. 13 ) DAX Formula to calculate Daily Moving Ave Profit Last 90 Days. Granularity: Daily. See the Function DATESINPERIOD to generate a va;id list of dates as a table for the AVERAGEX Function.
  14. 14 ) Excel Array Formula to calculate Daily Moving Ave Profit Last 90 Days. Granularity: Daily. See the functions: AVERAGE, SUMIFS, ROW and INDIRECT.
  15. 15 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.