Get the first issue planned on a project

Questions & Answers
1

In our projects we have a customized field that indicates the planned date for each issue.
How can I get the oldest scheduled start date from among all the issues that belong to a project?

2

Hi,

Perhaps, the simplest way would be to create a report like this and sort the issues by the date in ascending order:

image
image.png3364×702 180 KB

If you wish to see the date for each project in a separate cell you would need a calculated measure. There are standard function Min and Max in MDX which you can use for the custom calculation. The trick is, however, that those functions cannot work with the dates and you need to convert the data to the Timestamp (and back to a date later).

The formula would be the following:

TimestampToDate(
  Min(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created]>0
    ),
    DateToTimestamp([Measures].[Planned date])
  )
)

Note to set the date and time format for this custom measure.

image
image.png1616×734 85.3 KB

Kindly,
Janis, eazyBI support