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
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
Thanks a lot lauma, It is working.
1 Like