when i added the campaign key to the fact table i got the data between start and end date.
But now i want the data between precampaigndate and start date
I tried this expression,
({[Campaign].[PreCampaignDate]:[Campaign].[StartDate]},[Measures].[Sales])
but it is giving null as result..