Mark first occurance of a value as "new"

[TheHans]

Hi Guys,

I have a table which I update regularly with data coming from Excel. It could happen that I have the same information imported on different dates. I would like to mark the first occurence of a key, see table below.

The imported data is in the columns "Report Date" and "Key" and the column "IsNew" would be calculated by using DAX.

For me it is not clear how I can iterate over all keys and how I find out on which date this key came up for the first time.

Any idea how to solve this?

Many thanks in advance.

Hans

Report Date	Key	Is New
01.01.2021	A	yes
01.01.2021	B	yes
01.01.2021	C	yes
01.01.2021	D	yes
18.03.2021	A	no
18.03.2021	C	no
18.03.2021	E	yes
18.03.2021	F	yes
10.04.2021	A	no
10.04.2021	E	no
10.04.2021	G	yes
10.04.2021	H	yes

[amitchandak · Accepted solution]

@TheHans , Create a new column like

if([Report Date] = minx(filter(Table, [Key] =earlier([Key])),[Report Date]), "Yes", "No")

[TheHans]

Awesome! It worked. thanks for the quick solution.