How to find the last time when someone applied time to an account with multiple issues?

I want to create an aging report providing me with the last time when someone assigned their Tempo time to an account so that we can determine if the account can be closed.

I’m still a novice, but it seems to me that I need to created a calculated member to first identify the last Tempo time date for each issue and then another to compare these results for all the issues related to the Account and select the MAX date among this result.

My attempt in using the following calculated member for the first part of this query is accepted, but yields no results:

TimestampToDate(
Max(
Filter(
Descendants([Issue].CurrentMember),
[Measures].[Issues with Hours spent]>0
),
DateToTimestamp([Measures].[Hours spent])
)
)

Any help would be appreciated.

@TBooth
Try this formula:

Order(
Filter(
DescendantsSet([Time].CurrentMember,[Time].[Day]),
[Measures].[Issues with Hours spent]>0
),
[Time].Currenthierarchymember.Startdate,
BDESC
).item(0).startdate

Martins / eazyBI


Thank you! This worked perfectly for what I needed