MDX-Query example that returns list of months from start of year up to specified month
Q: Need a MDX query that returns list of months from start of year up to specified month.
A: You can use YTD function. Following example returns 2003 year members from January to March:
FROM [Sales Summary]
January 2003 February 2003 March 2003
$1,756,407.01 $2,873,936.93 $2,049,529.87