Get the last 5 Days, for each Month of the Year using MDX query 16. July 2013 Hans Esquivel Analysis Services , Analysis Services Tabular Mode , Multidimensional Expressions (MDX) Comments (0) In this session I'll show you how to script a query in MDX to get the last 5 days, for each month of a chosen year. After we test the query, we'll validate aggregate values for the first couple of months using a basic MDX query. [More]