Project Last updated date

Questions & Answers
,
4

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 discussing it in this community thread).

Lauma / support@eazybi.com