Fun with MDX-Part 3: YTD and Prior YTD Calculations

In this the third installment of this series I am going to walk through a simple and straight-forward solution to calculating the year-to-date sales for both the current year and prior year. We will work the calculation in two different queries to highlight their functionality.