Dax - calculate - date in filter

[jajamb]

Hi.

I am trying to create a calculate or something, which sums 2 different keys from another column, based on a date.

Eksample:
[Values] = Sum(Value)

Month 1-9 is from [VersionKey]="ACT"
Month 10-12 is from [VersionKey]="Budget"

[Date] = Date column (month 1-12 in date format)
[CarryforwardDate] = Month 10 (in date format) This is variable

Estimate:=CALCULATE([Values];FILTER(FactTableBudget;IF(FactTableBudget[Date]>FactTableBudget[CarryforwardDate];FactTableBudget[VersionKey]="Budget";FactTableBudget[VersionKey]="ACT")))

This returns blank for month 1-10.

Any sugestions?

 

[jajamb]

I found the problem..

Then [Carryforwarddate] was empty for "Act"

It works once this was corrected