New to power pivot formula advice

[donnalouiseb74]

I am trying to create a calculated colum which basically states that if the [Ticket_CloseDate] is blank and [Ticket_LastModifiedDate] is older than 4 days return a numerical value.


I've started with =IF(ISBLANK('table'[Ticket_CloseDate]&& TODAY() - 'table'[Ticket_LastModifiedDate]>4,<999>,< else condition >) but can't seem to get the rest of the statment to work


I'm new to powerpivot so any help would be helpful

 

[olivierhbh]

Hello,

Be sure that the field Ticket_LastModifiedDate has a date type.

And you missed a parenthesis in your formula.
=IF(ISBLANK('table'[Ticket_CloseDate]) && ((TODAY() - 'table'[Ticket_LastModifiedDate])>4),<999>,< else statement>)