How to write if condition in measures

[janis.plume]

Hi,

The exact solution depends on the report outlook.
This community post describes how to calculate the time difference between two status transitions per issue:

Days Diff field

Hi, The DateDiffDays function can use tuples to find the time between two transitions: DateDiffDays( ([Measures].[Transition to status first date], [Transition Status].[In Progress]), ([Measures].[Transition to status last date], [Transition Status].[Done]) ) This formula for an issue finds the days between the first transition to the In Progress till the last time issue transitioned to Done. Kindly, Janis, eazyBI support

Kindly,
Janis, eazyBI support