Forum Discussion
SQL/OLEDB - Return MAX based on multiple criteria
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,
1 Reply
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.
