SQL/OLEDB - Return MAX based on multiple criteria

[Anonymous]

Dears,

hope you can help me here with some SQL code on Query Editor. Connection is OLEDB.

I'd like to retrieve directly from source a clean set of data. This is, get lines with MAX date based on two criteria. See below my table.

For example, for "Order No_" = PC2116705 and "Order Line No_" = 10000, I'd need "Source ID" = LC2200174, since "Register Date" is the newer one.

Any clue on how to do it?

Thanks in advance,

[edhans]

This is a Power Query forum. If you need help with SQL code, a SQL forum would be the better place.

If you want to do this in Power Query with M code, when we'd need data to play with and show you code - I cannot work with an image and I'm not typing that in.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.