Completed
) Introduction
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 ) Introduction
- 2 ) What is Granularity?
- 3 ) Look at Data Model and Hide Columns from Client Tool
- 4 ) Basic DAX Calculation: Total Profit and Average Profit using the SUM Function and the AVERAGE Function
- 5 ) Start PivotTable with DAX Transactional Average for each month. Granularity: Transactional.
- 6 ) Excel Spreadsheet formula to calculate Transactional Average for each month using AVERAGEIFS function. Granularity: Transactional.
- 7 ) Discuss Filter Context and how it works in the Power Pivot Data Model
- 8 ) DAX Formula for Transactional Moving Ave Profit Last 90 Days using CALCULATE and DATESINPERIOD. Granularity: Transactional.
- 9 ) Excel Spreadsheet formula to calculate Transactional Moving Ave Profit Last 90 Days using AVERAGEIFS function. Granularity: Transactional.
- 10 ) Create Line Chart to plot Month Average and 90 Day Moving Average
- 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 ) 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 ) 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 ) Excel Array Formula to calculate Daily Moving Ave Profit Last 90 Days. Granularity: Daily. See the functions: AVERAGE, SUMIFS, ROW and INDIRECT.
- 15 ) Summary
