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])

ryan_mayu's avatar
ryan_mayu
Super User
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])

  • joepcf's avatar
    joepcf
    New Member
    6 years ago

    That works great - thanks a lot ryan_mayu