Hi ,

Can anyone help me out writing MDX for finding products wich are present for current date but not in previous date. Below is SQL query for the same.

select count(distinct Product) from table_A

where Date='2012-12-12'

and Product not in (select distinct Product from table_A

where Date='2012-12-01')

thanks in advance...

----Swapnil