Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
4 years ago
Solved

Summarize tabel on last date values

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 ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, icturion 

    You can add two calculated columns as below:

     

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

     

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

The other day I read an article about SUMMARIZE, and came away a bit shellshocked. 

 

All the secrets of SUMMARIZE - SQLBI

 

In a nutshell - you're likely better off using GROUPBY()

 

In any case you can add Lat and Lon to the groupings.