Using DATEDIFF with CALCULATE Function

[STrimpe]

I'm having an issue trying to combine the DATEDIFF statement with CALCULATE.

This first statement below works.

  AGE = DATEDIFF('ATI MainStage'[InitialLoanEstimateIssuesDate].[Date],TODAY(),DAY)

When I try to add a filter with the CALCUALTE function below, I am getting an error that a single value for variation 'Date' for the InitalLoanEstimateIssues date cannot be determined.  Is there a way to make this work?  

AGE = CALCULATE(DATEDIFF('ATI MainStage'[InitialLoanEstimateIssuesDate].[Date],TODAY(),DAY),

FILTER('ATI MainStage','ATI MainStage'[Milestone] IN {"Registered"}))

 

Thanks.

[nandic]

Hi,
You could use IF statement. Example:

Date Difference Calculate = IF('Table'[Type]="Registered", DATEDIFF('Table'[Date],TODAY(),DAY))

Regards,
Nemanja Andic