DAX Patterns collection
DAX Patterns is a collection of general, reusable solutions to commonly occurring business problems in Power BI, Power Pivot for Excel, and Analysis Services. Every pattern comes with in-depth video lectures; this is where Alberto Ferrari and Marco Russo explain how the pattern works so you can understand how to adapt the DAX code to your requirements.
You can pick and choose the pattern(s) that best fit your business challenges, or you may prefer to purchase our entire collection of over 20 patterns.
Get immediate access to the entire collection of patterns for a flat rate. Save money and time, discover new patterns and receive immediate updates every now and then.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
-
Standard time-related calculations
-
Month-related calculations
-
Week-related calculations
-
Custom time-related calculations
-
Comparing different time periods
-
Semi-additive calculations
-
Cumulative total
-
Related distinct countFree
-
Parameter table
-
Static segmentation
-
Dynamic segmentation
-
ABC classification
-
Budget
-
Survey
-
Basket analysis
-
New and returning customers
-
Currency conversion
-
Hierarchies
-
Parent-child hierarchies
-
Events in progress
-
Like-for-like comparison
-
Transition matrix
-
Ranking
Training Platform
This course is conducted through our training platform which is immersive and designed to facilitate your experience.