Without Time dimension, perform calculation only if issue created date is less than today

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

Hi,

Perhaps, the simplest and most efficient solution for this case is to subtract the issues created for the current date from the total issues created:

CASE WHEN [Time].CurrentMember is [Time].DefaultMember
-- time dimension not used in report
THEN
[Measures].[Issues created]
-
([Measures].[Issues created],
 [Time].[Day].CurrentDateMember)
END

Kindly,
Janis, eazyBI support