Project Last issue created date

[guinevere]

Hi,

I need to bulding a report that shows the project and the date of last issue created. Because, we have many active projects without use.

[gerda.grantina]

Hi @guinevere ,
You can use similar approach that is used in this community post answer:

Project Last updated date

Hi @Vishwas! I imagine this could be that for some dimension level there are no issues. Please try to wrap the function in the following CASE condition. CASE WHEN ([Measures].[Issues last updated], [Time].CurrentHierarchy.DefaultMember) > 0 THEN Tail( Filter( [Time].CurrentHierarchy.Levels("Day").Members, [Measures].[Issues last updated] > 0 )).Item(0).StartDate END If this does not work, please export report definition and send it to support@eazybi.com (mention that we are discus…

Only, you need to use measure “Issues created” instead of “Issues last updated”:

CASE WHEN ([Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember) > 0 
THEN 
Tail(
Filter(
    [Time].CurrentHierarchy.Levels("Day").Members,
    [Measures].[Issues created] > 0
  )).Item(0).StartDate
END

best,
Gerda // support@eazybi.com