Roll up measure based on Target start and end

Questions & Answers
1

Hello,

This is my first post. So I apologize if it is a noob question. I am using easyBI with Jira to build a progress chart. I am trying to roll up the expected hours complete, but I can’t seem to figure out how to do that.

I am trying to iterate over the descendants, but I keep getting nothing or everything back. Here is my current attempt.

Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateCompare([Issue].[Issue Target start],
[Time].CurrentMember.StartDate) <= 0),

– Please ignore this value, it will eventually be replaced with a meaningful calculation
1
)

Hopefully you can see that I only want the calculation to count if the start date is past the indexed date that is being applied. But this doesn’t seem to work. Is there any advice you can give?

Thanks,
Joel

2

Please disregard, I found out what I was doing wrong. Just for reference, this was the code that worked for me.

Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateCompare([Measures].[Issue Target start],
[Time].CurrentHierarchyMember.StartDate) <= 0),
– Please ignore this value, it will eventually be replaced with a meaningful calculation
1
)

1 Like
3

Yes, that’s how it works. you probably didn’t use the default hierarchy in the Time dimension, but another hierarchy.