Days Open Dax Calc


#1

I’m creating a problem management process dashboard and wanted a DAX calc that could calculate the number of days a ticket was or has been open. See chart below: If a ticket has been closed it has a openedat value (opened date) and closedat value (closed date) I’ve created a new column using Days Open = DATEDIFF(Data[openedat],Data[closedat],DAY) this gives me a days open value. However, if the ticket hasnt been closed it has NO closedat value so I have added another column which has todays date to give me a value. Todays Date = TODAY()

I’m looking for a measure that can calculate if closed use “Days Open” value, if open use number of days between “Openedat” and “Todays Date”Problem

Thanks Team


#2

You should be able to just use an if statement I would presume here.

Something like this

IF ( ISBLANK( Closedat ), TODAY() - Openedat, Closedat - Openedat )

Would this work?