Hi all!
I am having some trouble regarding the datesbetween function in powerpivot.
The basic issue:
I have 2 files:
- File1: file with sales pr day pr customer pr item ([Vol],[date],[customer],[item])
- File2: 1 file with customer promotions including a promotion start date and an end date. ([PromotionID],[customer],[startdate],[enddate],[item])
I would like to summarize for each Promotion what has been sold, and I tried something like this:
=calculate(sum(File1[vol]),datesbetween(File1[date],File2[startdate],File2[Enddate]),File1[customer]=File2[customer])
I keep getting a syntax error message on the datesbetween() function.... Anyone familiar with this function and able to assist?
BR
Jesper
(I'm also a bit unsure abount my 2nd filter in the calculate() function...)
Bookmarks