No Function matches for '[Time].[Day].DateMembersBetween' function

Questions & Answers
#1

Hi,
I am trying to define calculated member formula with below for Time dimension:

name:
[Time].[Last 7 Days]
caclulatedmember:
Aggregate(
[Time].[Day].DateMembersBetween(‘7 days ago’,‘today’)
)

it is almost the same with the samples in jira demo, but I got errors like below:
No Function matches signature ‘.DateMembersBetween(,)’

could you please let me know why the errors showing?

Thanks a lot
Best Regards
Annie Gao

#2

Hi @xinranmo

The function DateMembersBetween is added since eazyBI version 5.1.0, see https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datemembersbetween.

In older versions there was a longer syntax to calculate the same:

Aggregate(
  [Time].[Day].DateMember('7 days ago'):
  [Time].[Day].DateMember('today')
)

Lauma / support@eazybi.com

1 Like
#3

Thanks a lot lauma, It is working.

1 Like