Time dimension filter in Dashboard - short list required

Hi @AntonBDR

eazyBI creates members in the “Time” dimension automatically based on the date-picker field values from imported issues.
It is likely that previous years are created as members if some of the date picker for imported issues holds the value in that year.
Another reason could be when importing change history. eazyBI can find some changes in previous years and that is enough to create the member in the “Time” dimension.

In this case, we would recommend creating a new calculated member in “Time” dimension to filter time periods since 2020.
Try this formula:

Aggregate(Filter(
  [Time].[year].Members,
  DateBetween([Time].CurrentMember.StartDate,
    '2020-01-01','now')
))

See also the similar question about calculated members here:

Martins / eazyBI support

1 Like