I have a table where I want to create a column that shows a unique true to a logical rule. Per unique number i want to have a unique value based on the latest modification. The formula works, except when there is the same date in the modification. From the source I cannot eliminate this. Per number i want to have only one lastest

Table:
| Number | Modification | Is Latest |
| ——– | ———————– | ——— |
| 1 | 22-07-24 11:00:00 | True |
| 1 | 22-07-24 11:00:00 | True |
| 1 | 22-07-24 10:01:00 | False |
| 2 | 22-07-24 11:00:00 | True |
| 2 | 22-07-24 10:00:00 | False |
| 3 | 22-07-24 11:00:00 | True |

**Formula: **
Is Latest = var currentIDNo = Table[number] var latestDate = CALCULATE( MAX(Table[modification]) ,FILTER(ALL('Table') ,Table[number] = currentIDNo ) ) return IF(Table[modification] = latestDate, TRUE(), FALSE())