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