005 SUMX

DAX ESSENTIALS - DATA MODELLING FOR BUSINESS INTELLIGENCE

LECTURES

001 WHAT IS DAX (5:07)
002 OVERVIEW OF DATA AND INTERFACE (13:01)
003 FIRST DAX MEASURE (9:05)
004 PROFIT MARGIN (4:04)
006 PRACTICAL POWER BI EXAMPLES (7:08)
005 SUMX (9:04)
007 CALCULATE, FILTER AND ALL (16:02)
008 THREE WAYS TO FILTER (6:45)
009 HIGH TICKET TRANSACTIONS (8:59)
010 DISTINCTCOUNT (4:21)
011 ALLEXCEPT (5:07)
012 RANKX (9:52)
013 RANKX TOPN (8:29)
014 DATE TABLE AND YTD (10:21)
015 DATEADD, SAMEPERIODLASTYEAR, PREVIOUSMONTH (10:44)
016 USERELATIONSHIP (7:01)
017 PARETO (8:21)
018 WHATIF (5:19)
019 GROUPBY (6:08)
020 IF AND SWITCH (9:05)
021 AVERAGE PER CATEGORY (7:42)

SOLUTIONS