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