Latest confirmed date depending on the product

[Anonymous]

Hello people,

I need a column that gives me the latest confirmed date depending on the product.
Does anyone of you have an idea how to implement this, below I have created a small example.

Thanks in advance!

Product	Confirmation date	latest Date
1	06/16/21	06/24/21
1	06/18/21	06/24/21
1	06/24/21	06/24/21
2	06/17/21	06/22/21
2	06/22/21	06/22/21

with kind regards
Lukas

[Jihwan_Kim]

https://www.dropbox.com/s/6q26n6n2gpl17c3/keluv3.pbix?dl=0 

Latest date CC =
MAXX (
FILTER ( 'Table', 'Table'[Product] = EARLIER ( 'Table'[Product] ) ),
'Table'[Confirmation date]
)

[PaulOlding · Accepted solution]

Here's the DAX for a calculated column to get your desired result

Latest Date =

CALCULATE(

MAX(Products[Confirmation date]),

ALLEXCEPT(Products, Products[Product])

)