Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@LamSar ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.