cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
STrimpe
Frequent Visitor

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.
1 REPLY 1
nandic
Memorable Member
Memorable Member

Hi,
You could use IF statement. Example:

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors