Issue filter for Open issues with start date < today

Questions & Answers
1

Hello,
Hello,

I used this script but geeting error as below. Can anyone help me out?

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]

),
[Measures].[Issues created]
)

#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type NUMERIC; got value ‘Wed Jul 07 00:00:00 UTC 2021’ (DATETIME)

and i tried this script and getting an error for this script

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]
AND
[Measures].[Open issues]
),
[Measures].[Issues created]
)

Error - Formula is not valid:
No function matches signature ‘ AND ’

Thanks
Rohith

2

Hi Rohit,

The error message suggests it expected an integer value however instead got a DateTime value instead.

The DateCompare() function allows you to compare two dates, you might get what you need from that function.

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare