Forward DATESINPERIOD function

[gkaropo]

Hi All,
Working on a way to look at total Sales (DEMAND) for a period in the future. In the case below it is the period starting 5 months from now for a total of 3 months of sales.
Below is what I have.
It seems ok to me but am getting an error that says "a table of multiple values was supplied where a single value was expected.


ForwardSales:=calculate([DEMAND],DATESINPERIOD('DATE'[DATE],DATEADD('DATE'[DATE],5,MONTH),3,MONTH))


any help would be appreciated.
thanks