Need to create Time Calculated Member for Closed, Active and Future Sprints

I Have to create time dimensions for Closed, Active and Future sprints. Please help me with this.

Hi @VNRajuVallabhaneni,

When building calculated members in dimensions (like Time, Spirit, Project, etc.) you should use only members form the dimension in which you ar making the calculation. Do not mix members from different dimensions: Calculated members in other dimensions.

You might want to use another approach for the report. If you want to show time on the report row that matches the selected sprint, use the “Time within Sprint” measure to filter corresponding rows. Here is explained this approach with an examples:

Best,
Zane / support@eazyBI.com