Training agenda
  1. Preparing data model structure and relationships
    1. List tables
    2. Dates table (calendar) – functions CALENDAR(), CALENDARAUTO(), FORMAT()
    3. Calculated columns
    4. Data types
    5. Conversions
    6.  Active and non-active relationships
    7. Hierarchies
    8. Basic transformations with Power Query
  2. Quick measures
    1. Using predefined calculations
    2. Implementing predefined calculations in custom measures
  3. Most commonly used functions
    1. Aggregations: SUM(), SUMX(), AVERAGE(), MIN(), MAX(), RANKX()
    2. Counting: COUNT(), COUNTROWS(), DISTINCTCOUNT(), DISTINCTCOUNTNOBLANK()
    3. Lookup: REALATED(), LOOKUPVALUE()
    4. Error handling: DIVIDE(), BLANK(), SELECTEDVALUE()
  4. Calculations context
    1. CALCULATE()
    2. FILTER()
    3. ALL(), ALLSELECTED(), ALLEXCEPT()
  5. Dates intervals calculations
    1. SAMEPERIODLASTYEAR(), DATEADD(), PARALLELPERIOD()
    2. TOTALYTD(), TOTALQTD(), TOTALMTD()
    3. DATESYTD(), DATESQTD(), DATESMTD()
    4. DATESBETWEEN(), DATESINPERIOD()
    5. LASTNONBLANK(), LASTNONBLANKVALUE()
    6. USERELATIONSHIP()
  6. Logical functions
    1. IF()
    2. SWITCH()
  7. Good practices for creating measures
    1. Creating variables
    2. Comments
    3. Clear code structure
  8. Using parameters with calculations
    1. Creating table with parameter values
    2. Using and referring to parameters in formulas
  9. Filtering data based on sign in data
    1. USERPRINCIPALNAME()