Set Analysis between Date question

julianortiz — Wed, 21 Jul 2021 11:43:18 GMT

I have this data

I'm building a Straight table to show historical records, depending on a field selection ([Calendar Month Year])

e.g. If the user selects Jul-2021, i should see all records

If the user selects Jun-2021, I should see records match with selection (dates between Start and End date)

I am using this expression with Set Analysis in my Dimension

=Aggr(Only({
<
MonthYear = ,
[Program Name] = {'Prog 1'},
[Enrollment Status End Date]={"<=$(=MonthEnd(Max([Calendar Month Year])))"}
>
+
<
MonthYear=,
[Program Name] = {'Prog 1'},
[EnrollMent Status End Date Status] = {1}
>

}
Customer),
Customer
)

Currently, when i select Jun-2021, only shows

Any suggestions?

Thanks in advance.

Note1: [EnrollMent Status End Date Status] field is for check if the value is null (1: null, 0: not null).

Note2: [Calendar Month Year] field is from an island table.

topic Set Analysis between Date question in App Development

Set Analysis between Date question