Fundamentals of DAX in Power BI & Power Pivot

Fundamentals of DAX in Power BI & Power Pivot

ExcelIsFun via YouTube Direct link

1. Introduction and video topics

1 of 63

1 of 63

1. Introduction and video topics

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Fundamentals of DAX in Power BI & Power Pivot

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

  1. 1 1. Introduction and video topics
  2. 2 2. Topics in Video
  3. 3 3. Why we use DAX, M Code & Worksheet Formulas: What makes Each Special?
  4. 4 4. Review data, data structure, Excel files, Power BI Desktop files and pdf notes
  5. 5 5. What is DAX?
  6. 6 6. Comprehensive Discussion about Star Schema Data Model Components and how they interact with DAX: Columnar Database, Relationships, DAX Formulas, Hidden Columns
  7. 7 7. Calculated Columns
  8. 8 8. Row Context
  9. 9 9. Measures
  10. 10 10. Power BI Desktop Calculated Columns and Measures
  11. 11 11. Data Model PivotTable
  12. 12 12. Filter Context
  13. 13 13. COUNTROWS Function Super Charged COUNTIFS Function
  14. 14 14. Expanded Table Diagram
  15. 15 15. Implicit Measures
  16. 16 16. SUMX function and Iterator Functions to Replace Calculated Columns
  17. 17 17. Compare SUMX One Step Method to Calculated Column SUM Two Step Method
  18. 18 18. Row and Filter Context Work Together
  19. 19 19. Using Measures in other Measures
  20. 20 20. DIVIDE Function
  21. 21 21. CALCULATE Function to Change Filter Context
  22. 22 22. ALL Function to remove filters and get a Grand Total
  23. 23 23. % of Grand Total Measure
  24. 24 24. ALLSELECTED Function to get Filtered Grand Total and % of Filtered Grand Total
  25. 25 25. % of Parent Total DAX Measure: 1 ALLEXCEPT Function and 2 ALLSELECTED & VALUES
  26. 26 26. Compare ALL and VALUES Functions
  27. 27 27. CONCATENATEX Function
  28. 28 28. YOY Change Formula with SAMEPERIODLASTYEAR, CALCULATE, DIVIDE, HASONEVALUE and a special filtering Calculated Column in Data Table
  29. 29 29. Variables in DAX using VAR and RETURN
  30. 30 30. Calculated Helper Column to make Measure less complicated
  31. 31 31. Boolean Filters
  32. 32 32. Second Look at Filter Context
  33. 33 33. Overwrite Operation
  34. 34 34. FILTER & ALL for Boolean Filter
  35. 35 35. Logical Tests in FILTER and CALCULATETABLE Functions
  36. 36 36. FILTER & VALUES for Boolean Filter
  37. 37 37. KEEPFILTER to Convert Overwrite Operations to an AND Logical Tests
  38. 38 38. Boolean OR Logical Test with Double Vertical Bar Operator
  39. 39 39. Self Filtering Report with KEEPFILTER
  40. 40 40. Filter Context with KEEPFILTTERS
  41. 41 41. Boolean OR Logical Test with IN Operator
  42. 42 42. NOT Logical Test
  43. 43 43. Context Transition in Calculated Columns
  44. 44 44. Hidden CALCULATE in Measure
  45. 45 45. Context Transition in Iterator like AVERAGEX. Calculate Average Monthly Sales.
  46. 46 46. Context Transition and Filter Context
  47. 47 47. Context Transition Error: Iterate Over Table with Duplicate Errors
  48. 48 48. Context Transition: Correct Formulas and Incorrect Formulas
  49. 49 49. Context Transition Error: Iterate over Fact Table
  50. 50 50. Grain of Calculation & Iterator Functions for Transactional, Daily and Monthly Averages
  51. 51 51. Average using DISTINCTCOUNT to make a faster formula
  52. 52 52. Cardinality and Iterator Functions. See five examples of howto reduce cardinality and increase formula calculation speed
  53. 53 53. DAX Studio to time formulas. EVALUATE Command.
  54. 54 54. Complex Filter and Complex Filter Reduction Error from Overwrite process: KEEPFILTERS or Data Modeling?
  55. 55 55. KEEPFILTERS in Power BI Quick Measure
  56. 56 56. 12 Month Moving Average DAX Measure: CALCULATE, AVERAGEX, DATESINPERIOD, IF, MAX Functions
  57. 57 57. Table Filters in CALCULATE to go backwards across a Many-To-One Relationship
  58. 58 58. Unmatched Items in a Relationship
  59. 59 59. DAX Approximate Match Lookup
  60. 60 60. DAX to create Date Tables in Power BI using GENERATE, ROW, CALENDAR and more
  61. 61 61. Extract Data From Power Pivot Data Model using Existing Connections
  62. 62 62. Video Summary and Conclusions
  63. 63 63. Closing and Video Links

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.