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 DAX Measure in Measure Grid to Calculate MAX Quantity

3 of 15

3 of 15

) Build DAX Measure in Measure Grid to Calculate MAX Quantity

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.