EARLIER Function too Slow!

[rogerthat]

Hi,

I currently have the below calculated column and I suspect the EARLIER function is taking most of the memory when I try to refresh.

ObjectIndex =

CALCULATE (

    COUNT ( DATA[ID ),

    ALLEXCEPT ( DATA, DATA[ID )),

    DATA[Date )<= EARLIER ( DATA[Date] ) )

)

StatusStreak is dependent on the above.

DATA REFERENCE:

ID	Status	Date	StatusStreak	ObjectIndex
XYX	COMPLETED	4/15/2023	1	1
XYX	COMPLETED	4/16/2023	2	2
XYX	FAILED	4/17/2023	1	3
XYX	COMPLETED	4/18/2023	1	4
XYX	COMPLETED	4/19/2023	2	5
XYX	COMPLETED	4/20/2023	3	6
XYX	COMPLETED	4/21/2023	4	7
XYX	COMPLETED	4/22/2023	5	8
XYX	FAILED	4/23/2023	1	9
XYX	COMPLETED	4/27/2023	1	10
XYX	COMPLETED	4/28/2023	2	11
XYX	COMPLETED	4/29/2023	3	12
XYX	COMPLETED	4/30/2023	4	13
XYX	COMPLETED	5/1/2023	5	14
XYX	COMPLETED	5/2/2023	6	15
XYX	COMPLETED	5/3/2023	7	16
XYX	COMPLETED	5/4/2023	8	17
XYX	COMPLETED	5/5/2023	9	18
XYX	COMPLETED	5/6/2023	10	19
XYX	COMPLETED	5/7/2023	11	20
XYX	COMPLETED	5/8/2023	12	21
XYX	COMPLETED	5/9/2023	13	22
XYX	COMPLETED	5/10/2023	14	23
XYX	COMPLETED	5/11/2023	15	24
XYX	COMPLETED	5/12/2023	16	25
XYX	COMPLETED	5/13/2023	17	26
XYX	COMPLETED	5/14/2023	18	27
XYX	COMPLETED	5/15/2023	19	28
XYX	COMPLETED	5/16/2023	20	29
XYX	COMPLETED	5/17/2023	21	30
XYX	COMPLETED	5/18/2023	22	31
XYX	COMPLETED	5/19/2023	23	32
XYX	COMPLETED	5/20/2023	24	33
XYX	COMPLETED	5/21/2023	25	34
XYX	COMPLETED	5/22/2023	26	35
XYX	COMPLETED	5/23/2023	27	36
XYX	COMPLETED	5/24/2023	28	37
XYX	COMPLETED	5/25/2023	29	38
XYX	COMPLETED	5/26/2023	30	39
XYX	COMPLETED	5/30/2023	31	40
XYX	COMPLETED	5/31/2023	32	41
XYX	COMPLETED	6/1/2023	33	42
XYX	COMPLETED	6/2/2023	34	43
XYX	COMPLETED	6/4/2023	35	44
XYX	COMPLETED	6/5/2023	36	45
XYX	COMPLETED	6/6/2023	37	46
XYX	COMPLETED	6/7/2023	38	47
XYX	COMPLETED	6/8/2023	39	48
XYX	COMPLETED	6/9/2023	40	49
XYX	COMPLETED	6/13/2023	41	50
XYX	COMPLETED	6/14/2023	42	51
XYX	COMPLETED	6/15/2023	43	52
XYX	COMPLETED	6/16/2023	44	53
XYX	COMPLETED	6/17/2023	45	54
XYX	COMPLETED	6/18/2023	46	55
XYX	COMPLETED	6/19/2023	47	56
XYX	COMPLETED	6/20/2023	48	57
XYX	COMPLETED	6/21/2023	49	58
XYX	COMPLETED	6/22/2023	50	59
XYX	COMPLETED	6/23/2023	51	60
XYX	COMPLETED	6/24/2023	52	61
XYX	COMPLETED	6/25/2023	53	62
XYX	COMPLETED	6/26/2023	54	63
XYX	COMPLETED	6/27/2023	55	64
XYX	COMPLETED	6/28/2023	56	65
XYX	COMPLETED	6/29/2023	57	66
XYX	COMPLETED	6/30/2023	58	67
XYX	COMPLETED	7/1/2023	59	68
XYX	COMPLETED	7/2/2023	60	69
XYX	COMPLETED	7/3/2023	61	70
XYX	COMPLETED	7/4/2023	62	71

Is there an alternative to what I'm trying to do without having to impact performance?

[Greg_Deckler · Accepted solution]

@rogerthat You could try this:

ObjectIndex =
VAR __Date = MAX(DATA[Date])
VAR __Return = 
CALCULATE (
    COUNT ( DATA[ID ),
    ALLEXCEPT ( DATA, DATA[ID )),
    DATA[Date )<= __Date ) )
)
RETURN
  __Return