Chapter 3. Working with Time

In this chapter, we will cover:

• Calculating the YTD (Year-To-Date) value

• Calculating the YoY (Year-over-Year) growth (parallel periods)

• Calculating moving averages

• Finding the last date with data

• Getting values on the last date with data

• Calculating today's date using the string functions

• Calculating today's date using the MemberValue function

• Calculating today's date using an attribute hierarchy

• Calculating the difference between two dates

• Calculating the difference between two times

• Calculating parallel periods for multiple dates in a set

• Calculating parallel periods for multiple dates in slicer