Summarize tabel on last date values

Question

Hi,I have a table with data (see table below).From the table, I only want to use the records with the last time per value in the column "kenteken". I also want to be able to use the values ​​in the columns lon and lat.&nbsp;This is what i got so far:New table --&gt; Laatste locatie = SUMMARIZE(AQZ_TRAVEL_MON,AQZ_TRAVEL_MON[Kenteken], "Laatst bekend", MAX(AQZ_TRAVEL_MON[Date time]))&nbsp;result isHow do i now included the columns lon en lat with the correnspondig values?

v-easonf-msft · Accepted Answer

Hi,&nbsp;icturion&nbsp;
You can add two calculated columns as below:
&nbsp;
lon =
LOOKUPVALUE (
    AQZ_TRAVEL_MON[lon],
    AQZ_TRAVEL_MON[kenteken], 'Laatste locatie'[kenteken],
    AQZ_TRAVEL_MON[Date time], 'Laatste locatie'[Laatst bekend]
)
lat = 
LOOKUPVALUE (
    AQZ_TRAVEL_MON[lat],
    AQZ_TRAVEL_MON[kenteken], 'Laatste locatie'[kenteken],
    AQZ_TRAVEL_MON[Date time], 'Laatste locatie'[Laatst bekend]
)
&nbsp;

&nbsp;
Best Regards,Community Support Team _ EasonIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Summarize tabel on last date values

2 Replies

Related content

Parameter in summarize

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters

Don't Summarize....still summarizes...?

calculate with summarize vs values

GroupBY and summarize