Hi
We are trying to perform some calculation, when the issue created date is less than current date. There are other calculations, which should not stop on current date.
Time dimension is NOT added on row or column.
CASE WHEN (DateDiffDays([Measures].[Issue created date], Now()) >= 0) THEN
Sum(
Head(
ChildrenSet([JIRA Bug Created Milestone].[Created Sorted Order]),
Rank([JIRA Bug Created Milestone].CurrentMember,
ChildrenSet([JIRA Bug Created Milestone].[Created Sorted Order])
)
),
([Measures].[Issues created], [Platform].[ABCDEF])
)
END
Wondering how can we fix this.
Thanks,
Vrukesh