Get a value of Remaining Estimated Hours measure form specific date

Hi @elopezz
Welcome to the eazyBI community!

You may want to use the measure “Remaining Estimated Hours history” to retrieve a remaining estimate at the end of a particular date.
And function DateMember() to get the Time dimension Day level member of the transition: MDX Function Reference

Puttin it together, you would get a tuple:

(
[Measures].[Remaining estimated hours history],
[Time].[Day].DateMember(
 ([Measures].[Transition to status first date],
  [Transition Status].[Ready],
  [Time].CurrentHierarchy.DefaultMember))
)

Hope it works for you!

Best,
Ilze, support@eazybi.com

1 Like