Forum Discussion

icturion's avatar
icturion
Resolver 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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
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.