Filter Member in Tuple by End Date

Questions & Answers
#1

Hi,
I need a Measure, which prints “1” in row cell*, when Member is in this filter:

issuetype = CTE and enddate > "2023-03-15"
  1. I’ve Imported “End Date” as Measure,Property and can deal with it as
[Issue].CurrentHierarchyMember.get('End date')
[Measures].[Issues with End date] --printed in report table like "Apr 04 2022"
  1. I can see that this Tuple mostly works as I need
(
[Measures].[Issues with End date],
[Issue Type].[CTE],
[Time].[2023].[Q1 2023].[Mar 2023]
)

but how to filter this Tuple with enddate > "2023-03-15"?

*the structure of levels I’m working with you can see in this thread
https://community.eazybi.com/t/total-of-descendants-in-collapsed-expanded-view/11353

#2

Hi,

Great that you have imported this date both as a property and a measure!

If you have issues in the report rows, you can use CASE WHEN construction where you compare the imported End date property with your target date and return 1 if, for this issue, the end date is larger than March 15, 2023. For comparing dates, use the DateCompare function

case WHEN
 DateCompare([Issue].CurrentHierarchyMember.get('End date'), 
 "2023-03-15")>0
THEN
 1
end

Also, you may add the “Issue type” property in columns and filter by this column: Regular expressions

Best,
Ilze , support@eazybi.com