Filter Issues Based on Target Due Date

Questions & Answers
1

Hello.

I need to show issues that have Target Due Date in the past (before today).
I have a measure [Measures].[Issue Target Due Date] in my measures.
How do I create a formula for this?

Thanks a lot!
Dana

2

Found a solution and I will share it in case someone else needs it:

CASE WHEN
[Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember
THEN
– when no time dimension is used in the report get today
SUM(
PreviousPeriods(
[Time].CurrentHierarchy.Levels(“Day”).CurrentDateMember),
[Measures].[Issues with Target Due Date]
)
WHEN
– with time dimension in the report apply the calculation for past dates and today only
DateAfterPeriodEnd(“Today”, [Time].CurrentHierarchyMember)
OR
DateInPeriod(“Today”, [Time].CurrentHierarchyMember)
THEN
SUM(
PreviousPeriods(
[Time].CurrentHierarchyMember),
[Measures].[Issues with Target Due Date]
)
END

1 Like