DAX Content:
Video/Class Project
18:
Video to watch:
MSPTDA 18: DAX Iterators, Table Functions,
Grain, Cardinality, Materializing Tables Excel & Power BI ( 1
hour 7 mins)
Download all 14 files used in video, including
homework files as zipped
folder: FilesUsedInVideo18.zip
Start files for Video/Class Project to download:
018-MSPTDA-DAX-IteratorsTables-Start.xlsx
Zipped Folder with data that was
already loaded into previous file (018-MSPTDA-DAX-IteratorsTables-Start.xlsx ):
018Files.zip
018-MSPTDA-DoubleCountStart.pbix
018-MSPTDA-ALLVALUES-Start.xlsx
018-MSPTDA-BigData.pbix
Zipped Folder with data that was
already loaded into Two previous "BigData" files:
018BigDataTextFiles.zip
Finished files (completed after video done):
018-MSPTDA-DAX-IteratorsTables-Finished.xlsx
018-MSPTDA-DoubleCountFinished.pbix
018-MSPTDA-ALLVALUES-Finished.xlsx
pdf Notes Handout to download:
018-MSPTDA-DAX-IteratorsTables.pdf
Assigned Homework:
Download Word Document and read:
HomeworkVideo018.docx
Then download the rest of the files and complete the
homework:
018-MSPTDA-HomeworkFile01Start.pbix
Examples of Finished Homework:
018-MSPTDA-HomeworkFile01Finished.pbix
018-MSPTDA-HomeworkFile02Finished.pbix
Video/Class Project
19:
Video to watch:
MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS
(50 Examples) ( 1 hour 48 minutes)
Download all 20 files used in video as zipped folder: FilesUsedInVideo19.zip
13 individual files available here:
Start files for Video/Class Project to download:
019-MSPTDA-CALCULATE-FilterContext-01-Start.xlsx (Excel File)
019-MSPTDA-CALCULATE-FilterContext-01-Start.pbix (Power BI File)
019-MSPTDA-CALCULATE-FilterContext-02-Start.pbix
(Power BI File)
019-MSPTDA-CALCULATE-FilterContext-03-Start.xlsx
(Excel File)
019-TableFilterExamplesStart.xlsx (Excel
File)
019-StarSchemaDataModel.xlsx (Excel File)
This file just has picture of Star Schema Data Model
019-SnowFlakeDataModel.xlsx
(Excel File)
This file just has picture of Snow Flake Data Model
Finished files (completed after video done):
019-MSPTDA-CALCULATE-FilterContext-01-Finished.xlsx (Excel File)
019-MSPTDA-CALCULATE-FilterContext-01-Finished.pbix (Power BI File)
019-MSPTDA-CALCULATE-FilterContext-02-Finished.xlsx (Excel File) ... There
is no start file for this. This is used for an example in the pdf notes.
019-MSPTDA-CALCULATE-FilterContext-02-Finished.pbix (Power BI File)
019-MSPTDA-CALCULATE-FilterContext-03-Finished.xlsx (Excel File)
019-TableFilterExamplesFinished.xlsx (Excel File)
pdf Notes Handout to download:
019-MSPTDA-CALCULATE-FilterContext.pdf
Assigned Homework:
Download Word Document and read:
HomeworkVideo019.docx
Then download the rest of the files and complete the
homework:
019-MSPTDA-HomeworkStart.xlsx
019-MSPTDA-HomeworkStart.pbix
Examples of Finished Homework:
019-MSPTDA-HomeworkFinished.xlsx
Video/Class Project
24:
Video to watch: MSPTDA
24: DAX Multiply / Divide Data Types Discrepancies Solved! ( 8 min)
Individual files available here for each section of the video:
Start:
024-MSPTDA-NumberDataTypesMath-Start.xlsx
Finished:
024-MSPTDA-NumberDataTypesMath-Finished.xlsx
pdf Notes Handout to download:
024-MSPTDA-MultiplyDivideAndDataTypes.pdf
Assigned Homework: NONE
Video/Class Project
31:
Video to watch: MSPTDA
31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT? ( 15 min)
Download all 6 files used in video as zipped folder: FilesUsedInVideo31.zip
pdf Notes Handout to download: 031-MSPTDA-FasterAverages.pdf
Assigned Homework: NONE