Using DATEDIFF with CALCULATE Function

STrimpe — Wed, 10 Feb 2021 19:46:11 GMT

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.

Re: Using DATEDIFF with CALCULATE Function

nandic — Wed, 10 Feb 2021 22:01:08 GMT

Hi,
You could use IF statement. Example:

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

Regards,
Nemanja Andic

topic Using DATEDIFF with CALCULATE Function in DAX Commands and Tips

Using DATEDIFF with CALCULATE Function

Re: Using DATEDIFF with CALCULATE Function