Add column that will display the first / new load date that the row appeared

[ambillate]

Hi Good Day,

I have this table that shows ID, Load Date, Product # and Section.

I want to add a column that will display the first load date that the row appeared, but if the row will not appear on the next load date (or will skip a date) and will apear again on the next-next load date, the date that must appear is the new load date.

This is my desired output:

I tried using this measure,

Date Appeared =

VAR firstload = Sheet1[Load Date]

VAR mindate = CALCULATE(MIN(Sheet1[Load Date]), ALLEXCEPT((Sheet1), Sheet1[Product No], Sheet1[Section]))

RETURN

IF(Sheet1[Load Date] = CALCULATE(MIN(Sheet1[Load Date]), ALLEXCEPT((Sheet1), Sheet1[Product No], Sheet1[Section])), firstload, mindate)

and I got this result,

I find it hard to display the new load date.

Hope that you help me with this.

Thanks a lot..

[ambillate]

Hi @Jihwan_Kim, 

I tried to use your measure, it already works now in rows 17.

But when I add new rows, the date that will display is still the min date. 

Is there any way to come up with this output (kindly see sample output below)?

Thanks a lot for helping me Sir.

[Jihwan_Kim · Accepted solution]

Link to the revised PBIX file 

[ambillate]

Hi @Jihwan_Kim, I really appreciate the time you spent for helping me. 

Thank You So much Sir.

[Jihwan_Kim]

Link to the PBIX file