Forum Discussion

Draszor's avatar
Draszor
Icon for Helper III rankHelper III
4 years ago

Replace Value based on latest date - how to apply the solution

Hi,   I want to replace project name ("Column6" of my table) for each project number ("Project" column of my table) with the name used for most fresh "Extraction Date". I found the solution it her...
Need Help
liuqi_pbi's avatar
liuqi_pbi
Icon for Resolver III rankResolver III
4 years ago

Hi Draszor 

 

Can you please mock up some dummy data and paste it in your post? Also remember to share your expected result based on that. This could help us understand your requirement better and provide a possible solution quickly. 

  • Draszor's avatar
    Draszor
    Icon for Helper III rankHelper III
    4 years ago

    Hi liuqi_pbi,

    this is a very good advise. thank you. I worked out the example and placed in on my Google_Drive.

     

    you can notice that Project Names do change with time. I would like to keep (for all the same Project numbers, irrespectively of Extractin Date) the latest name for a given project number. 

    that means - for project number WR10849757, I should see Red 11 name for all extraction dates

     

    BR

    Draszor