Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country

Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country

ExcelIsFun via YouTube Direct link

) Build Relationships Between Tables. Discussion “Filter Context” and of how Criteria from PivotTable filters Lookup Tables and how the “filter” flows across the Relationship to “filter the Fact tabl…

6 of 15

6 of 15

) Build Relationships Between Tables. Discussion “Filter Context” and of how Criteria from PivotTable filters Lookup Tables and how the “filter” flows across the Relationship to “filter the Fact tabl…

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country

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

  1. 1 ) Introduction
  2. 2 ) Build CountCategory Table in Excel. Learn about Table Formula Nomenclature in Excel Table.
  3. 3 ) Build DAX Measure in Measure Grid to Calculate MAX Quantity
  4. 4 ) Import CountCategory Table into Data Model
  5. 5 ) Create Automatic dCalendar Table in Power Pivot
  6. 6 ) Build Relationships Between Tables. Discussion “Filter Context” and of how Criteria from PivotTable filters Lookup Tables and how the “filter” flows across the Relationship to “filter the Fact tabl…
  7. 7 ) Build DAX Calculated Column in Fact Table to use in Relationship to CountCategory Table. Discussion of Columnar Database and how columns with a small number of unique values do not take up much RAM…
  8. 8 ) Build PivotTable based on Data Model
  9. 9 ) Sort Count Category Column by Upper Value Column so categories sort correctly in PivotTable
  10. 10 ) Build DAX Measure Frequency Formula to count # transactions with specified quantity. Description of How Data Model and DAX Formulas calculate when criteria is applied in a PivotTable. See the COUNT…
  11. 11 ) Finish Building PivotTable.
  12. 12 ) Add Slicer to PivotTable
  13. 13 ) Add Conditional Formatting to PivotTable
  14. 14 ) Add Formatting to Dashboard
  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.