Find the first date of each data entry

[Serj]

Hi all,

Would you pls help me with this one.

I have multiple entries of data for several dates (Observation Date). What I want to do - is to create a calculated column with the first date of occurence (First Occurence) for each of those entries. Would you pls help me with the correct logical expression for that column. Many thanks in advance!

Example:

Observation Date	Entry #	First occurence
1-Jan-2022	Entry1	1-Jan-2022
15-Jan-2022	Entry1	1-Jan-2022
20-Jan-2022	Entry1	1-Jan-2022
10-Jan-2022	Entry2	10-Jan-2022
22-Jan-2022	Entry2	10-Jan-2022
5-Jan-2022	Entry3	5-Jan-2022
6-Jan-2022	Entry3	5-Jan-2022
7-Jan-2022	Entry3	5-Jan-2022
8-Jan-2022	Entry3	5-Jan-2022
30-Jan-2022	Entry4	30-Jan-2022

[Serj]

@amitchandak Perfect! Thank you!

[amitchandak · Accepted solution]

@Serj , a new column

minx(filter(data, Data[Entry #] = earlier(Data[Entry #])), Data[Observation Date])

a new measure

minx(filter(allselected(data), Data[Entry #] = max(Data[Entry #])), Data[Observation Date])