Thanks for the reply. I think I may be stuck on updating other dependent measures in this though. Specifically, in order to get “predicted on” you must update “Project start date” which appears to get timestamps from resolutions.
see:
–annotations.group= Predicted by issues
– projects starts at the moment when the first issue is resolved from any In progress status
DateWithoutTime(TimestampToDate(
([Measures].[Transition from first timestamp],
[Resolution].[(unresolved)],
[Transition Field].[Resolution],
[Transition status.Category].[In Progress],
[Time].CurrentHierarchy.DefaultMember)
))
– old version
– Cache(
– – First date with issues resolved will be project Start date
– Filter([Time].CurrentHierarchy.Levels(‘Day’).Members,
– [Measures].[Issues resolved] > 0
– ).Item(0).StartDate
– )
What would need to change here in order to not be dependent on resolution? I’ve tried a few things but I’m guessing my MDX isn’t cutting it