Forum Discussion

joepcf's avatar
joepcf
New Member
6 years ago
Solved

Create a column using the latest value from a table

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 dat...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    joepcf 

    Please try

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

amitchandak's avatar
amitchandak
Super User
6 years ago

joepcf , Try as new columns

LatestName =

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

joepcf's avatar
joepcf
New Member
6 years ago

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.