Only the latest confirmed date should be returned in one column

[Anonymous]

Hi guys
I have a table in which process steps of a product are reported back, as you can see in the example.Now I would like to have a column that always shows the last reported date per product.

Example :

Produkt	Process Step	Confirmation date	latest date per product
1	1	12.05.2021
1	2	14.05.2021
1	3	17.05.2021
1	4	20.05.2021	20.05.2021
2	1	18.05.2021
2	2	19.05.2021	19.05.2021
2	3
2	4
3	1	16.05.2021
3	2	17.05.2021
3	3	21.05.2021	21.05.2021
3	4

Thanks in advance
Greetings Lukas

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

it is for creating a new column.

Latest date per product CC =

VAR latestdate =

MAXX (

FILTER ( 'Table', 'Table'[Produkt] = EARLIER ( 'Table'[Produkt] ) ),

'Table'[Confirmation date ]

)

RETURN

IF ( 'Table'[Confirmation date ] = latestdate, 'Table'[Confirmation date ] )

https://www.dropbox.com/s/ikqjbd63ay2psju/kelu.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM