Introduction to time intelligenceBuilding a Date tableUsing CALENDAR and CALENDARAUTOWorking with multiple datesHandling multiple relationships to the Date tableHandling multiple Date tablesIntroduction to time intelligenceUsing Mark as Date TableAggregating and comparing over timeYear-to-date, quarter-to-date, month-to-dateComputing periods from prior periodsComputing difference over previous periodsComputing the moving annual totalClosing balance over timeSemi-additive measuresOPENINGBALANCE and CLOSINGBALANCE functionsAdvanced time intelligenceUnderstanding periods to dateUnderstanding DATEADDUnderstanding FIRSTDATE and LASTDATEUnderstanding FIRSTNONBLANK and LASTNONBLANKUsing drillthrough with time intelligenceCustom calendarsWorking with weeksCustom year-to-date, quarter-to-date, month-to-dateComputing over noncontiguous periodsCustom comparison between periods