I have a fact table that stores customer statuses based on when they last chaged. e.g.
Customer Status DateAttained
Cust 1 Live 20130801
Cust 1 Suspended 20130625
Cust 1 Live 20120901
Cust 1 Activated 20120731
So assuming I queried the end of year 2012, I would get a "Live Status" or if I queried their status as of 26th june 2013, I get "Suspended"
This is straightforward for SQL but no clue how to do it in MDX.