• 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..