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