Calculate incremented sales due to a promotion

[LamSar]

Good morning,

I have a question about 2 calculations I have to make.

The requirements are:

- Calculate average sales 4 weeks before the start of the promotion and 4 weeks after the end of the promotion (Calculation A-

- Calculate the sales during the promotion (Calculation B)

- Incremented sales = Calculation B - Calculation A

The table.fields to be used are:

- Date from = Datum[datumVan]

- Date to = Datum[DatumTot]

- ArticleDescription = RetailArtikel[Description]

- Total Sales = CALCULATE(SUM(Verkoop[BedragInclBTW]),ALL(Promotie))

I have no idea on how to do this.

Any suggestions?

[amitchandak]

@LamSar ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.