Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.