SSAS MDX Query for date comparision data

 Author Message swapp Valued Member Group: General Forum Members Points: 52 Visits: 17 Hi friends,Can anyone help me out for writing MDX for finding products which are present for current date but not in previous date. Below is SQL query for the same.select count(distinct Product) from table_Awhere Date='2012-12-12'and Product not in (select distinct Product from table_Awhere Date='2012-12-01')thanks in advance...----Swapnil Mackers SSCommitted Group: General Forum Members Points: 1737 Visits: 499 Try something along the lines ofwith set [Product List] AsNONEMPTY({[Product].[Product Level 4].[All].Children}, ([Measures].[Revenue],[Date].[Day].&[20121212]))-NONEMPTY({[Product].[Product Level 4].[All].Children}, ([Measures].[Revenue],[Date].[Day].&[20121201]))select [Product List] on rows,{[Date].[Day].&[20121201],[Date].[Day].&[20121212]} on columnsfrom [Your Cube]where ([Measures].[Revenue])Mack swapp Valued Member Group: General Forum Members Points: 52 Visits: 17 Thank you for your reply...Here "Date" is dimention and count(distinct product) i calculated as measure.---Swapnil swapp Valued Member Group: General Forum Members Points: 52 Visits: 17 Hi Mack,thank you for your help. Working fine now.......Swapnil swapp Valued Member Group: General Forum Members Points: 52 Visits: 17 Hi All,Can anyone help me out in this.I have below result, C1 C1 C1 26-Nov-12 3-Dec-12 10-Dec-12Count Of Product 196 162 210% L Count 45.18% 40.49% 49.49%% C Count 54.82% 59.51% 79.51%% New Items 0.00% 0.00% 0.00%Here in % New items i want to write MDX to show the product present for 10-Dec-12 but not in 3-Dec-12,03-Dec-12 but not in 26-Nov-12 according to this product present for 26-Nov-12 are 100% bcoz no previous date is selected.thanks Swapp