Date Range

[smanas]

Please advise the formula for date range 

I'm trying to get count of ID base don EligibiltyDate >'09/01/2022'

Thank you

[MarcoWedel]

Count({$<EligibiltyDate={">09/01/2022"}>} ID)

[BrunPierre]

Count({$<EligibiltyDate={">09/01/2022"}>} ID)

Read more on modifiers with searches here Numeric searches 

[smanas]

Thank you but I have duplicates in the ID column I would need to use only >eligibilitydate"09/01/2022" and remove duplicates as IU dont see count distinct please advise

[BrunPierre]

Provide some data and the desired result.

[smanas]

Hi @BrunPierre  Here is the data and below is the desired result. Thank you

ID	EligibilityDate
1	1/12/2021
2	9/10/2078
3	5/12/2022
3	10/1/2078
4	9/1/2078
5	7/2/2022
5	1/10/2078
6	1/5/2022
6	7/9/2078

Desired Result

ID	EligibilityDate
2	9/10/2078
3	10/1/2078
4	9/1/2078
5	1/10/2078
6	7/9/2078

[BrunPierre]

ONLY({<EligibilityDate={">09/01/2022"}>} Aggr(FirstSortedValue(Date(EligibilityDate,'M/D/YYYY'),-EligibilityDate),ID))

[vinieme12 · Accepted solution]

Dimensions:

ID

Measures:

latest EligibilityDate: 

max({<EligibilityDate={">09/01/2022"}>}EligibilityDate)

Distinct Count:  

count(Distinct aggr(max({<EligibilityDate={">09/01/2022"}>}EligibilityDate),ID))