Chapter 10. Working with Dates and Time Intelligence

In this chapter, we will cover the following recipes:

• Creating a date table in Visual Studio

• Using the CALENDAR function

• Modifying the date table with the YEAR function

• Modifying the date table to include month data

• Using the NOW and TODAY functions

• Using the DATEDIFF function

• Using the WEEKDAY function

• Understanding time intelligence

• Using the FIRSTDATE function

• Using the PARALLELPERIOD function

• Calculating Year over Year Growth

• Using the OPENINGBALANCEMONTH function

• Using the OPENINGBALANCEYEAR function

• Using the CLOSINGBALANCEMONTH function

• Using the CLOSINGBALANCEYEAR function

• Using the TOTALYTD function