First occurrence of an Item in a table

[DataXcelGPT]

I have the following table. I would like to create another table which lists an ItemNo and the first date it occured in the table.  

Date	ItemNo
1/1/2022	100
2/2/2022	200
1/1/2022	100
3/3/2022	300
2/2/2022	200
4/4/2022	400
3/3/2022	300
1/1/2022	100
1/1/2022	100
3/3/2022	300
2/2/2022	200
4/4/2022	400
3/3/2022	300
1/1/2022	100
1/1/2022	100
3/3/2022	300
2/2/2022	200
4/4/2022	400
3/3/2022	300
1/1/2022	100

[DataXcelGPT]

@Greg_Deckler That solution worked.  Thanks

[Ashish_Mathur]

Hi,

Drag Item No to the Table and write this measure

First data = min(Data[Date])

Hope this helps.

[Ashish_Mathur]

Hi,

Drag Item No to the Table and write this measure

First data = min(Data[Date])

Hope this helps.

[Greg_Deckler · Accepted solution]

@DataXcelGPT Try:

Calculated Table = SUMMARIZE('Table', [ItemNo], "Date", MIN('Table'[Date]))