I am looking for a way to filter on Weekly time to show only 2019 or date range
In the example I only want to show 2019 and not any of the previous years
I have used the following code to show the companies Fiscal Year and wanting to do the same in Weeks
Aggregate(Filter(
[Time].[Month].Members,
DateBetween([Time].CurrentMember.StartDate,
‘Dec 01 2018’, ‘Nov 30 2019’)
))
Hi @briantaylor ,
In this case, you would need to create a new calculated member with more sophisticated code:
Try exploring examples on our demo account:
https://eazybi.com/accounts/1000/cubes/Issues/
Perhaps something similar would be the following code:
Aggregate(Filter(
[Time.Weekly].[Week].Members,
DateBetween([Time.Weekly].CurrentMember.StartDate,
'Dec 1 2018', 'today')
))
It would include all weeks which start within the defined range.
Note that weeks that start at the end of November and fall in this range would be excluded.
Martins / eazyBI support