Forum Discussion
Solved
EARLIER Function too Slow!
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?
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
1 Reply
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