Keeping data based on export date and unique occurrences

Hello everyone,   I have to create a report via Power Query which has a technical difficulty that I seem incapable to work around. The ERP we use flushes data more than 6 months old, so for example...