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

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

[Time].[Last 7 Days]
[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

Hi @xinranmo

The function DateMembersBetween is added since eazyBI version 5.1.0, see

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

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

Lauma /

1 Like

Thanks a lot lauma, It is working.

1 Like