Get latest value for relationship

Hi all,

I have three different tables with

• Devices
• Sender
• Connections (which device is on which sender)

As the connections table does not only hold current connections but also historic data I need to create a table out of that only holding the latest connection per device.

Looking my example above I need to extract one line per "device_id" with the latest "registration_date". Usually the "deregistration_date" is empty so it could be sufficient to filter by empty "deregistration_date" but I am looking for safe implementation filtering the latest "registration_date".

Any idea on how to to that in the Power Query? I think it needs to be done there in order to be able to user that result in the relationships later.

Thx a lot!