Issue due date measure (without future issue's)

Questions & Answers
1

Hi all,
I’m trying to see all the issue’s with due date in it, i have issue due date measure but it show all the future issue’s which i don’t want.
Is there any way to get only the issue’s with due date until the end of the current week?

2

Hi @Idan_Fuss,
You can use measures “Issues with due date” and add the “Time” dimension in your report to filter the period you are interested in.

time_members
time_members1538×842 117 KB

You can also create calculated members in the “Time” dimension to change different periods, e.g. here is a formula for “Last 4 months by weeks”:

Aggregate(
  [Time.Weekly].[Week].DateMembersBetween('4 months ago', 'today')
)

Kind regards,
Gerda // support@eazyBI.com