Create a column using the latest value from a table

[joepcf]

Hi,

Any help you can give on this would be greatly appreciated. 

I am looking to create a new column on a table that will show the most recent Name value using the URL. Here is my current dataset: 

ID	Timestamp	Name	URL
1	29/06/2020	Page 1	http://www.web.com/page1
2	30/06/2020	Page 1.1	http://www.web.com/page1
3	30/06/2020	Page 2	http://www.web.com/page2
4	1/07/2020	Page 2.1	http://www.web.com/page2
5	2/07/2020	Page 2.2	http://www.web.com/page2

I would like to output the following:

ID	Timestamp	Name	URL	LatestName
1	29/06/2020	Page 1	http://www.web.com/page1	Page 1.1
2	30/06/2020	Page 1.1	http://www.web.com/page1	Page 1.1
3	30/06/2020	Page 2	http://www.web.com/page2	Page 2.2
4	1/07/2020	Page 2.1	http://www.web.com/page2	Page 2.2
5	2/07/2020	Page 2.2	http://www.web.com/page2	Page 2.2

The LatestName column should look for the URLs that match and find the most recent item and use that Name value. Any ideas?

[ryan_mayu · Accepted solution]

@joepcf 

Please try

Column = 
MAXX(FILTER('table','table'[URL]=EARLIER('table'[URL])&&'table'[ID]=CALCULATE(MAX('table'[ID]),ALLEXCEPT('table','table'[URL]))),'table'[LatestName])

[joepcf]

That works great - thanks a lot @ryan_mayu 

[amitchandak]

@joepcf , Try as new columns

LatestName =

if(not(containsstring([name],".")) ,[Name]&".1",[Name])

[joepcf]

Hi @amitchandak - thanks for your response.

The page names may well be random values - "MY content page", "News article ABC", etc. etc. - so I need to use the URL as the key.