• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query Min & Max / first & last date

Dear Fellas

I have a table of 3 columns with Order date, Order No and invoice # information. If an invoice contain one order Min and Max date should be the same as order date. however if the invoice is having more than one order then first date of order should be min and last date or another order should be max. I was looking out for a power query solution. plz help.
 

Attachments

  • PowerQuery-Min Max date.xlsx
    9.3 KB · Views: 1
Like this you mean?
upload_2018-6-28_18-46-13.png

Then extract the details from the last table if still required to have in the result table.
 

Attachments

  • Copy of PowerQuery-Min Max date.xlsx
    19 KB · Views: 0
Back
Top