Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Update value based on latest date

I'm new in Power Query Excel. I'm trying to update value in the column 3 based on unique value created by combining two columns ID 1 and ID 2. If the unique value is duplicated, value in column 3 wi...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Anonymous 

    group your table on columns "ID1" and "ID2" with 2 aggregations: MAX on column "Date created" and "All" (no column selection for that)

    Then expand the resulting "All"-column with all but the "Date created" column (because this column is already there with the latest date of the combination).

     

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Anonymous 

group your table on columns "ID1" and "ID2" with 2 aggregations: MAX on column "Date created" and "All" (no column selection for that)

Then expand the resulting "All"-column with all but the "Date created" column (because this column is already there with the latest date of the combination).