Forum Discussion

STrimpe's avatar
STrimpe
Frequent Visitor
5 years ago

Using DATEDIFF with CALCULATE Function

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.
CALCULATE
DATEDIFF

1 Reply

  • nandic's avatar
    nandic
    Resident Rockstar
    5 years ago

    Hi,
    You could use IF statement. Example:

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