Filter Time In Weeks with dates

I am looking for a way to filter on Weekly time to show only 2019 or date range

10%20AM
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