Completed
) Discuss Filter Context and how it works in the Power Pivot Data Model
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
