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
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago
#"Replace Project Names" = Table.Combine(Table.Group(#"Expanded PromoteHeaders","Project",{"n",each let NewLocation=Table.First(Table.Sort(_,{"EXTRACTION DATE",1}))[Column6] in Table.ReplaceValue(_,null,NewLocation,(x,y,z)=>z,{"Column6"})})[n])