Forum Discussion
How to exclude oldest timestamp from CALCULATE ( MIN (... function
I have a column with modified timestamps. The goal is to write the earliest modification date for every ID BUT exclude the very first one which is the same as ticket creation date. So I need to exclude the timestamp where the time in MUOKATTU (*modified*)is the same as LUOTU -column
I have tried using IF etc. but the problem is that I need that EARLIER to work correctly. Please advice.
Reaction-Timestamp =
CALCULATE(
MIN(
'Tickets'[Modified]);
FILTER('Tickets';'Tickets'[ID] = EARLIER('Tickets'[ID])
)
)
Hi Anonymous,
My formula is a measure, if you put it in a calculated column, it may get the wrong result.(measure will limit the calculate range to row, but calculate column will calculate the full column)Measure:
Reaction-Timestamp(Measure) = MINX(FILTER(ALL(Tickets),Tickets[ID]=MAX(Tickets[ID])&&Tickets[Modified]<>Tickets[Created]),Tickets[Modified])
BTW, if you want to use calculate column, you can try to use below formula:
Reaction-Timestamp = MINX(FILTER(ALL(Tickets),Tickets[ID]=EARLIER(Tickets[ID])&&Tickets[Modified]<>Tickets[Created]),Tickets[Modified])
Regards,
Xiaoxin Sheng
10 Replies
Hi Anonymous,
To open up my scenario:
- I have multiple rows with same ID (One row for every modification)
- I have created 2 additional columns. One for First timestamp and other for lates.
- I want to write the same stamp for every row (Earliest for Reaction-timestamp and Latest for Resolution-Tmes
The resolution (Latest) works like I want BUT I have a problem with the first (Reaction). The earliest timestamp is in fact the same as the creation date timestamp (Luotu). I mean that the same timestamp is also recorded on Modified-column (Muokattu). So I would nee the function to exclude the earliest timestamp and write the second earliest timestamp for every row in Reaction-Timestamp
Ofcourse For every ID. I hope this clarifies the case. Thanks for your inputs.